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
<tbody>
</tbody>
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>