Add colour

[acos3ltd]

Dear,

How can i add the colour to excel use follow this formula
1 = red colour
2 = yellow colour
3 = white colour
.......

Many Thanks
Joh

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/colors.htm

 

[Oda Yujiro]

If only you have less than 4 conditions, then you can use
(From Format-Menu|Conditional Formatting
in order for you to color any cells/range.
*** Don't miss "Add Button" on the dialog of "Conditional Formatting)
( You can only use twice, that means you can set three different conditions)
May be it depends on your Excel version whether you have this option or not.
Good Luck!