Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing color of a row
Is there any way to change the color of the row based on the value of PM in
the cell and then check the rest of the spreadsheet for the PM value and change the color of the rest of the row? See example below. Project Amount PM Color desired 123 125000 DG red 234 26715 CG blue 345 1243 EG green 456 258000 CG blue 567 12589 CG blue 678 77500 DG red 789 65875 EG green |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Button Color | Excel Discussion (Misc queries) | |||
Changing Cell Color | Excel Worksheet Functions | |||
changing tab color conditionally | Excel Discussion (Misc queries) | |||
changing the color of the buttons | Excel Discussion (Misc queries) | |||
Changing color in color palette | Setting up and Configuration of Excel |