Help with if and conditional formatting
HI!! I need a little help with a formula.
I am using this formula and is working as I want to:
=IF(AND($E5="",$F5="",$G5="",$H5="",$I5=""),"",esp anol!$U5)
However, now I want a cell to change color to red if $E5="",$F5="",$G5="",$H5="",$I5="",f5 is more than 69% ),"", change e5 to red
what I want is that if any of the cells E5 to I5 in espanol! has something and the F5 in ingles! is less that 69% then change to red, but if from E5 to I5 has something but F5 is more that 69% the nothing happens.
Hope it makes sense.
any help will be gladly appreciated!
Liz
|