conditional DATE formatting?

Giganews Newsgroups
Subject: conditional DATE formatting?
Posted by:  LTUser54 (
Date: Thu, 18 May 2006

I want to highlight dates greater than 1/1/2006 in a column of numbers.

I've been poking around with Conditional formatting for about 30
minutes with this and getting nowhere.

I put DATE(2006,1,1) in cell A1, selected a small range of cells that
go from 12/05 to 2006 and tried using CellValueIs      greater than
="$a$1"  and selected bright green background for the cell.

that didn't work.

Any suggestions, please?

LTUser54's Profile:
View this thread: