| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating A Row
Hi, I have a spreadsheet of items that need to be watched for expiration....
Column E has the Expiration Date... I need a formaula (I think for the conditional formating) to have the row highlight when the it's 60 and 30 days to expiration. I tried the =and(E1:E1000<"",today()-30) It did not work.... Thanks any help would be appriciated. -- Jules |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating is greyed out and unavailable | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| excel conditional formating decimal fractions | Excel Worksheet Functions | |||
| Conditional formating using formulas | Excel Worksheet Functions | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Threaded Mode
