Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Help
Mission:
Trying to have cells under column A turn red if the adjacent B cell is empty, and is 15 days overdue. Attempt: Conditional formatting =A1+15<=NOW() [Red Font] Conditional formatting =A1<B1 [Default Font] Success!! Problem: I want to do the same thing with A2 to B2 A3 to B3 etc....However if I highlight lets say the entire column, the entire column ill be dependent on that one cell. I need a way to do this so that each cell react to the cell to the right just like I did in my example above. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Help
On Aug 5, 2:16*pm, John Adly <John
wrote: Mission: Trying to have cells under column A turn red if the adjacent B cell is empty, and is 15 days overdue. Attempt: Conditional formatting =A1+15<=NOW() * [Red Font] Conditional formatting =A1<B1 * * * * * * * * * [Default Font] Success!! Problem: I want to do the same thing with A2 to B2 A3 to B3 etc....However if I highlight lets say the entire column, the entire column ill be dependent on that one cell. I need a way to do this so that each cell react to the cell to the right just like I did in my example above. Anchor your column with a $... Conditional formatting=$A1+15<=NOW() Conditional formatting=$A1<$B1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |