View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] mcarnold@gmail.com is offline
external usenet poster
 
Posts: 4
Default 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.