Conditional formatting cell based on the value of the adjacent cell

[z75455]

I have tried everything I have found on conditional formating and I can not get it to work.

The data in my cells is generated for formulas so I don't know if that is the problem.

I would like to highlight column B based on the value in column C.

If Column C is less that 1 or equal to Zero the Cells In B need to highlight red

If Column C is Greater than 0, The cells in B needs to highlight green.

Can you help me please?


A b c
=IF(L3,N3/L3,0) =IF(L3,M3/L3,0) =VLooKUp

Average Audit Score<strike></strike>	Average % Difference	Weekly Audit Count<strike></strike>
0	0%	0
95	1%	1
100	10%	1
0	0	0

<tbody>
</tbody>

 

[jtakw]

Re: Conditional formatting cell based on the value of the adjacent cell= Help Please-I have trid eveVLrything i could find

Hi,

It's rather simple to come up with CF formula rules Except you have over-lapping criteria...

So if C is Between 0 and 1, it would Match Both Conditions ??

 

[z75455]

Re: Conditional formatting cell based on the value of the adjacent cell= Help Please-I have trid eveVLrything i could find

Hi,

It's rather simple to come up with CF formula rules Except you have over-lapping criteria...

So if C is Between 0 and 1, it would Match Both Conditions ??

Hey thanks for the reply, I was up pretty late trying to get it done and I had to turn in the report without that function,then the holidays hit.

As for the data, it can be less than less than 1.

_ Have tried conditional formatting with =$M:$M<1

 

[Fluff]

Re: Conditional formatting cell based on the value of the adjacent cell= Help Please-I have trid eveVLrything i could find

Highlight the data in col B (eg B2:B100) & use this formula
=C2<=1
and
=C2>1