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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Average Audit Score<strike></strike>
[/TD]
[TD]Average % Difference[/TD]
[TD]Weekly Audit Count<strike></strike>
[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]0%
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]95
[/TD]
[TD]1%
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]10%
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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