Conditional Formatting with Dates
 

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?

Conditional Formatting with Dates
 

Format-Conditional format
Formula is:
=K3<39273
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Maggie" wrote:

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?

Conditional Formatting with Dates
 

I'm assuming your date is July 10 2007.

Try this:

In Excel versions 2003 and earlier

Select cell BA3
Goto the menu FormatConditional 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

--
Biff
Microsoft Excel MVP


"Maggie" wrote in message
...
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?