| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date conditioning format problem
I am using excel 2000.
with my cursor in A1, I select cell A1 to A20 which is already in date format, and do a conditioning format(highlight) using IsFormula: =$A$1=TODAY() Unfortunately, all the cells from A1 to A20 are highlighted!!!!!! no matter the dates is today or otherwise!!!!!!!! In fact all the cells are having the same conditioning format which is =$A$1=TODAY(). How to make it suvch that cell AX is having =$A$X=TODAY()conditioning format??? |
|
#2
|
|||
|
|||
|
Date conditioning format problem
Hi
Take the Absolute off the row Reference =$A1=TODAY() Regards Roger Govier wrote: I am using excel 2000. with my cursor in A1, I select cell A1 to A20 which is already in date format, and do a conditioning format(highlight) using IsFormula: =$A$1=TODAY() Unfortunately, all the cells from A1 to A20 are highlighted!!!!!! no matter the dates is today or otherwise!!!!!!!! In fact all the cells are having the same conditioning format which is =$A$1=TODAY(). How to make it suvch that cell AX is having =$A$X=TODAY()conditioning format??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Customized Date Format | Excel Worksheet Functions | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
| format the "date" button for a header | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
Linear Mode
