| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i make excel to highlight today using conditional formatin
Hi,
give this a try, works fine for me. In the conditional formatting box change to 'Formula Is' and set the formula to: =$A$1=TODAY() Marc "Kinghart" wrote: hi experts.... can u tell me to highlight today in a table using conditional formating. I used this formula, but it didn't work =today() and selected the RED colour -- Kinghart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating to highlight dates 30, 60, and 90 days out? | Excel Worksheet Functions | |||
| Highlight the day of today | Excel Discussion (Misc queries) | |||
| How do you make Conditional Formating work? | Excel Worksheet Functions | |||
| Applying conditional formating to make cells change color | Excel Discussion (Misc queries) | |||
| Conditional formating using today() +/- 180 days | Excel Worksheet Functions | |||
Threaded Mode
