| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format an entire row based on one cell
Is there any way to have an entire row shaded based on a value in that row. I
want rows to be shaded once if a date in the row has passed. I have tried using the =IF($V3<TODAY,1,0) and then selecting my shading colour, having highlited the entire row, but nothing happened. Any help would be greatly apprecaited. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format a row based on a cell? | Excel Worksheet Functions | |||
| Conditional format based on entire row | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| Conditional Format to change entire row based on one cells data | Excel Discussion (Misc queries) | |||
| Can I format an entire row based on the value of a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
