M Maggie Feb 24, 2009 #1 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?
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 Feb 25, 2009 #3 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
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
