conditional DATE formatting?

Giganews Newsgroups
Subject: conditional DATE formatting?
Posted by:  LTUser54 (LTUser54.280rqm_1147983000.7921@excelforum-nospam.com)
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
------------------------------------------------------------------------
LTUser54's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=33459
View this thread:http://www.excelforum.com/showthread.php?threadid=543464

Replies