5
57Caddy
Rather than creating a bunch of new fields, is it possible to conditional
format a field that has a formula in it? I've attached what I have below for
cell D5. We want anything 3 or greater to have the whole cell green and
anything below 3 to be red.
Thank you
=IF(C5>=17.5%,"5",IF(C5>=16.25%,"4",IF(C5>=14.25%,"3",IF(C5>=13%,"2",IF(C5>=0,"1","N/A")))))
format a field that has a formula in it? I've attached what I have below for
cell D5. We want anything 3 or greater to have the whole cell green and
anything below 3 to be red.
Thank you
=IF(C5>=17.5%,"5",IF(C5>=16.25%,"4",IF(C5>=14.25%,"3",IF(C5>=13%,"2",IF(C5>=0,"1","N/A")))))