Excel Question

[MrCodeDude]

I want to do a small IF command where if a certain % is less than 20%, the cell's fill color will turn red. Is there a way to do this via formula?

 

[MikeyIs4Dcats]

use conditional formatting

 

[MrCodeDude]

Eh?

 

[n0cmonkey]

WRONG FORUM

 

[MikeyIs4Dcats]

for cell A1 when B1 is .20

Format>conditional formatting

if CELL VALUE is LESS THAN OR EQUAL TO "B1" and set FORMAT to have red fill

 

[sygyzy]

I was trying to do it a fancier way with conditional but Mikey is correct. You have to have B1 somewhere be 20%, then you can just evaluate against it.

 

[MrCodeDude]

Thanks :heart:

 

[KLin]

I guess all of the other forums except Off Topic are broke. :roll:

 

[warcrow]

Originally posted by: n0cmonkey
WRONG FORUM