Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing colors of a cell
My problem is that I need to change the colors of cells based on the values
of Lot 51, East Pavilion and West Pavilion if you could help me out with this that would be great |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing colors of a cell
See if you can work with this.
If Cells(Lot51Row, Lot51Col) = "YourCriteriaValue" Then Range("CellsToChangeColor").Interior.ColorIndex = ANumberFrom1To56 End If "Ben" wrote: My problem is that I need to change the colors of cells based on the values of Lot 51, East Pavilion and West Pavilion if you could help me out with this that would be great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell colors | Excel Discussion (Misc queries) | |||
Changing cell colors in a row IF... | Excel Programming | |||
Changing cell colors in a row IF... | Excel Programming | |||
Changing the colors of a cell | Excel Programming | |||
Cell contents changing colors | Excel Programming |