Coloured backgrounds using IF
 

Hi I am looking to format teh colour of cells using their values

ie
equal to or less than 5 Green
6 to 14 yellow
15 and greater red

any help greatly appreciated.

Coloured backgrounds using IF
 

You would use Conditional Formatting to do this - available on the
Format menu. Just follow the Wizard through and choose the Patterns
tab for background colour.

Hope this helps.

Pete

On Dec 8, 1:52*pm, Simon wrote:
Hi I am looking to format teh colour of cells using their values

ie
equal to or less than 5 Green
6 to 14 yellow
15 and greater red

any help greatly appreciated.

Coloured backgrounds using IF
 

Hi Simon,

Highlight the cells and choose Format + COnditional Formating
Press the Add button twice - this will give you three lines.
1 - Change Between to Less than or Equal to, type 5 - Click Format and
choose Green
2 - Type 6 and 14 - Click Format and choose Yellow
3 - Change between to Greater or Eqaul to, typr 15 - Click Fornat and choose
Red

Judith

--
Hope this helps


"Simon" wrote:

Hi I am looking to format teh colour of cells using their values

ie
equal to or less than 5 Green
6 to 14 yellow
15 and greater red

any help greatly appreciated.

Coloured backgrounds using IF
 

Assume that you are having Values in A column like the below:-

A Col
4
5
2
6
6
3
15
14
13
12
8
5
88

Place the cursor in A1 cell and extend the selection by holding the shift
and down arrow upto your desired cell, keep in mind that the active cell
should be A1 (Active cell will have a white background after selection also)

now goto formatconditional formattingCondition 1Formula ispaste the
below formula
=AND($A1<=5,$A1<"")
Click FormatPatternColourGreen and give ok.

Then Click AddCondition 2 Formula ispaste the below formula
=AND($A1=6,$A1<=14)
Click FormatPatternColourYellow and give ok.

Then Click AddCondition 3 Formula ispaste the below formula
=$A1=15
Click FormatPatternColourRed and give ok.

That's it!

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Simon" wrote:

Hi I am looking to format teh colour of cells using their values

ie
equal to or less than 5 Green
6 to 14 yellow
15 and greater red

any help greatly appreciated.