View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Using Dates in Conditional Formatting

Put it all in Condition1

=AND(ISNUMBER(G3),G3<TODAY())

Delete Condition2


Gord Dibben MS Excel MVP


On Mon, 17 Aug 2009 09:15:02 -0700, Marie FP
wrote:

I’m using conditional formatting to change the color of a cell to blue if the
date entered in that cell is less than today’s date. The formula works fine
as long as there’s any date in the cell. The problem is when the cell is
empty, it is also turns blue, but I would like it to have no formatting. I
tried to fix this by adding a second condition, but it still didn’t work.
Does anyone know how I can fix this? My conditions look like this:

Condition 1: Forumla Is =G3<TODAY() --- color is blue.
Condition 2: Cell Value Is equal to 0 --- color is no color