Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with Dates | Excel Worksheet Functions | |||
Conditional Formatting with Dates | New Users to Excel | |||
conditional formatting using dates | Excel Discussion (Misc queries) | |||
Dates in Conditional Formatting help!!! | Excel Worksheet Functions | |||
Conditional Formatting Dates | Excel Worksheet Functions |