Conditional Formatting with Dates

M

Maggie

I want to use conditional formatting to black out a cell(BA3), if cell
K3 is before 07/10/2007. How do I do that?
 
T

T. Valko

I'm assuming your date is July 10 2007.

Try this:

In Excel versions 2003 and earlier

Select cell BA3
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(K3<>"",K3<DATE(2007,7,10))
Click the Format button
Select the Patterns tab
Select the black fill color
OK out
 
Top