1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Struggling to make the IF and AND functions work

Hi all,

I'm trying to make a sheet that uses conditional formatting with what I assume is the IF and AND functions.

https://preview.redd.it/3ar2hizivcsg1.png?width=270&format=png&auto=webp&s=0fd14961beffa89c89dccacbcdaafa75891d0b82

Essentially what I want is "if H3 is greater than 0, and I3 is "no", then I3 turns red", I just can't seem to make it work!!

can anyone give me some advice how to make this work?

thanks in advance!

submitted by /u/Poppy_1712
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article