Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change the color of a range of cells
Hi,
I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change the color of a range of cells
Hi,
apply conditional formating to cells 1 to 4, use where the formula is and enter the cell you want to compare, let's say A5 then the option in my example less than 3 =A5<3 choose your color hope this helps "Srajes" wrote: Hi, I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all thse 5 cells depending up on the value in cell 5. Thanks in advance for your help. SR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change color of a range of cels in a row based on the value in one | New Users to Excel | |||
change background color based on range value | New Users to Excel | |||
How do I change background color of highlighted Excel range ? | Excel Discussion (Misc queries) | |||
change font color if number Range changes | Excel Worksheet Functions | |||
How can you change the color of the selected range? | Excel Discussion (Misc queries) |