Excel 2002: How to conditional format band of colors ?
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
|