Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formating a cell with a conditional if statement
I'd like to write an if statement that would compare a
date to todays's date and if the date is before today's date color the cell red and if after today's date color the cell green. Any suggestions on how to write the if statement? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formating a cell with a conditional if statement
Create a defined name (Ínsert/Name/Define)
Let it refere to a formula like this Today() name it ThisDay Then create a conditional formating saying Cell value / Less then / =Thisday Wendel "Rich" skrev i meddelandet ... I'd like to write an if statement that would compare a date to todays's date and if the date is before today's date color the cell red and if after today's date color the cell green. Any suggestions on how to write the if statement? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating for the whole row, based on one cell value | Excel Discussion (Misc queries) | |||
Conditional formating a cell containing a date | Excel Worksheet Functions | |||
conditional cell formating | Excel Discussion (Misc queries) | |||
Conditional formating on if statement | Excel Worksheet Functions | |||
cannot access conditional formating for a cell, why? | Excel Discussion (Misc queries) |