Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color row based on cell value
I see several posts about conditional formatting.
As a novice what I need is a walkthrough no matter what the solution! I would like to color a row yellow at a certain date, then red at another. This is for a project and the yellow and red correspond to due dates. Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red. I would also like to color a row (some color) when a 100% is reached in the "completed %) cell. Help is appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color row based on cell value
Format/ Conditional Formatting/ Formula is
=$A1=DATE(2009,12,11) Select your yellow format Add Formula is =$A1=DATE(2009,12,19) Select your red format Add Formula is =$B1=100% Select your appropriate colour Adjust the references if the date is in a different column than A and if the completed cell is in a different column than B, but notice that the address is absolute for the column and relative for the row. Check the position of the $ signs in the cell references. -- David Biddulph "tbo" wrote in message ... I see several posts about conditional formatting. As a novice what I need is a walkthrough no matter what the solution! I would like to color a row yellow at a certain date, then red at another. This is for a project and the yellow and red correspond to due dates. Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red. I would also like to color a row (some color) when a 100% is reached in the "completed %) cell. Help is appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color row based on cell value
This looks promising. Seems the answer lies in conditional formatting.
Must be easy when you know what you're doing. ;) http://www.asap-utilities.com/blog/i...-a-cell-value/ "tbo" wrote: I see several posts about conditional formatting. As a novice what I need is a walkthrough no matter what the solution! I would like to color a row yellow at a certain date, then red at another. This is for a project and the yellow and red correspond to due dates. Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red. I would also like to color a row (some color) when a 100% is reached in the "completed %) cell. Help is appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the color of a cell based on the color of another cell. | Excel Discussion (Misc queries) | |||
Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions |