Presuming row1 is left empty (data from row2 down), this seems to work ok
Select cols A to C, then apply the cond format formula for condition 1 as:
=AND($A1<"",OR(OFFSET($A1,1,)=$A1,OFFSET($A1,-1,)=$A1))
Format the fill to taste, OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ups.com...
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.