| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting a date
How do i make a cell change colour
a) if the date entered in it has passed B) if it is before that date |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting a date
How do i make a cell change colour
a) if the date entered in it has passed Select the range, eg select A2:A10 (A2 active), then apply CF using Formula Is: =AND(A2<TODAY(),A2<"") Format to taste OK The additional check: A2<"" is to prevent blank cells (if any) from spuriously triggering the CF -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:370 Subscribers:66 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Conditional formatting on Date | Excel Worksheet Functions | |||
| Conditional Formatting A Date | Excel Discussion (Misc queries) | |||
| conditional formatting date | Excel Discussion (Misc queries) | |||
| Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
Linear Mode
