Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Colours / Colors
Hello,
I am familar with the formula and its variations where you can have basic alternating colour / color rows. For example: =MOD(ROW(),2)=1 would make Row 1, Row 3, Row 5, etc. colored. I have a SUPER simple question, yet I can't find a simple answer anywhere on here. I need a formula that does essentially this, but switches colors for the row when a new value is added in column "A." For example, if: A B C 1 Tree Flower Mushroom 2 Tree Cat Dog 3 Rose Snow Star 4 Moon Sun Cloud 5 Star Fog Leaf 6 Star Fog Dog 7 Horse Cow Goat I would want Rows 1 & 2 to be shaded (corresponding with the value in column A), Row 3 to be unshaded, Row 4 to be shaded, Rows 5 & 6 to be unshaded, Row 7 to be shaded and so on. Most importantly, if I were to add a row after Row 4 for instance, then the color function would automatically adjust. Any help would be grand! Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) |