Conditional Formatting and IF

P

prkhan56

Hello All,
I am using Office 2003

I have a worksheet where I need to put text in Column A depending on
the dates in column B and I have used CF as follows: It is giving an
error

=if(AND($B1>TODAY(),$B1<TODAY()+29),"Check","")

I need to put the Word "CHECK" in Column A if the Date in column B
exceeds above 30 days, or leave it blank

I tried but I failed..
Can anyone give me a clue

Thanks

Rashid
 
J

JE McGimpsey

You can't add text to a cell using Conditional Formatting - you can only
change the format.

instead, enter your formula directly into the cell:

A1: =IF(AND($B1>TODAY(),$B1<(TODAY()+29)),"Check","")
 
Top