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