| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I modify the color of a cell?
I am an Excel beginner, but learning a lot from the experts in this newsgroup. My problem is simple - I have two cells that I am monitoring. If cell 2 is larger in value than cell 1 (a1 < a2), then I need to "highlight" the the cell next to them in Red. If the A1 < A2 condition exists, I call a UserForm and will change the background color of that 3rd cell via an offset in the Userform. What I don't know how to do is change the background color. I would appreciate any help that can be offered. Thank you
JP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I override conditional format to modify color of 1 cell? | Excel Discussion (Misc queries) | |||
| modify a standard color like in 2003 | Excel Discussion (Misc queries) | |||
| How can you modify the background color of a cell by using formul. | Excel Worksheet Functions | |||
| Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
| Macro to Modify Pivot Table for Color and Bold | Excel Worksheet Functions | |||
Threaded Mode
