Add colour

  • Thread starter Thread starter acos3ltd
  • Start date Start date
A

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
 
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!
 
Back
Top