Having colour for different values

B

Brento

Hi All,

Could someone please help me I have been searching the web for hours
trying to solve this puzzle? My formular reads
=IF(L19<=22%,"Green","Red") and all I get is the word i have also tried
=IF(L20<=22%,N19,N20) and in N19 is a green Yes and in N20 is a red No.

What I am looking for is a formular that if a value of less than 22% is
entered then that value is red or if over then the value is green.

I am at my wits end trying everything to try and solve this. :mad:
 
R

Ron Coderre

I think what you're looking for is Conditional Formatting:

Select cell L19
Set the font color to Green

Then
Conditional Formatting (from the Excel menu)
Cell value is: Less than or equal to .22
Click the [Format...] button
--->Select red font color....Click [OK]...... Click [OK]

Does that help?
Ron
 
R

Rowan

You need to use Conditional Formatting on the cells. Format > Conditional
Formatting.

hth
Rowan
 
Top