Conditional Formatting

[dsami0122]

I have two cells one with a mulitplier and one blank

What I am trying to do is:

If the Multiplier is below 3.00 then it will Turn Red
If the Multiplier is above 3.00 but lower than 3.5 it will turn yellow
If the Multiplier is above 3.5 it will turn green

How can I do this with conditional formatting?

 

[dsami0122]

I have two cells one with a mulitplier and one blank

What I am trying to do is:

If the Multiplier is below 3.00 then it will Turn Red
If the Multiplier is above 3.00 but lower than 3.5 it will turn yellow
If the Multiplier is above 3.5 it will turn green

How can I do this with conditional formatting?

I also tried to do something like this and couldnt get it to work
=IF([@Multiplier]<3, "LOW"), IF(AND([@Multiplier]>3,[@Multiplier]<3.5,"MID"), IF([@Multiplier]>4.0, "HIGH"))))

 

[Asbestos_Jen]

My Excel is too old to upload Conditional Formatting, but this is what it would look like if your Multiplier is in Column A. It looks like you have your data formatted as a table, but your formula isn't using it quite right for the Multiplier Level.

Your formula will work like this (but your "high" is segregated at 4, instead of 3.5 like your original post, so you may want to change that to 3.5).

Book1
	A	B	C
1	Multiplier	Multiplier Level
2	3.44	MID
3	3.18	MID
4	2.65	LOW
5	2.77	LOW
6	3.19	MID
7	3.09	MID
8	2.63	LOW
9	3.01	MID
10	3.47	MID
11	3.46	MID
12	4.09	HIGH
13	2.94	LOW
14	3.43	MID
15	3.15	MID
16	3.92	FALSE
17
Sheet1

Cell Formulas
Range	Formula
B2:B16	B2	=IF(Table1[[#This Row],[Multiplier]]<3,"LOW",IF(AND(Table1[[#This Row],[Multiplier]]>3,Table1[[#This Row],[Multiplier]]<3.5),"MID",IF(Table1[[#This Row],[Multiplier]]>4,"HIGH")))