Hi,

Conditional formating feature in Excel helps to brighten up the worksheet
and makes analysing data a lot easier and less stressful.

May I know how to conditional format repeated bands of colors in the
folowing example ?

Eg 1:
A ... M

1 Green
2 Yellow
3
200


E.g 2
A ... M

1 Green
2 Yellow
3 Red
200


E.g 3
A .... M

1 Green
2 Yellow
3 Red
4 Blue
5
200

Kindly show me the Formula 1, 2, 3 and 4 in the dialog box for each example
and the area needs to be highlighted before formating.


Many Thanks

Low


--
A36B58K641