Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: Question
I need to figure out how to do the following:
Conditional formatting (I know how to define the formatting, just not the conditions) in B1. If a1 has a date in it, and b1 is empty, and 10 days or more have passed since A1.....format with the identified format. You geniuses are BEYOND awesome! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: Question
try
Formula Is =AND(ISNUMBER($A1), $B1="", TODAY()-$A1=10) "VegasSageV" wrote: I need to figure out how to do the following: Conditional formatting (I know how to define the formatting, just not the conditions) in B1. If a1 has a date in it, and b1 is empty, and 10 days or more have passed since A1.....format with the identified format. You geniuses are BEYOND awesome! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting: Question
thank you so much.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Another conditional formatting question. | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Worksheet Functions | |||
Conditional Formatting question... | Excel Discussion (Misc queries) | |||
Conditional formatting question | Excel Worksheet Functions |