Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting of Rows Based On More Than 4 Conditions
I am trying to work around the 4 condition limit in Xcel's conditional
formatting so that I can change the background color of each row in my spreadsheet based on the text that is in the cell in the 3rd column of each row. That cell will contain one of six alternatives such as "On Hold", "Completed", etc. I assume that I will have to write some sort of macro to format the rows. I'm less than a novice at writing macros using VBA, so please keep it simple. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I highlight rows based on conditional formatting | Excel Worksheet Functions | |||
How to use conditional formatting for rows, based on info in cells | Excel Discussion (Misc queries) | |||
Conditional Formatting based on 2 conditions | Excel Discussion (Misc queries) | |||
Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
How do I use conditional formatting on all rows based on data | Excel Discussion (Misc queries) |