| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
In Excel, can I shade entire rows based on the value of a single .
I'm trying to format rows in my spreadsheet based on the values existing in
two cells on that row. If the date is before today, and there is no entry in another cell, I want the entire row to be yellow. If the date is before today, and there IS an entry in another cell, I want the entire row to be green. If the date is after today, the other cell doesn't matter. In this case, the entire row would be white (or clear). Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove empty rows in excel? | Excel Discussion (Misc queries) | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
| How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
| Hiding rows based on date | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
