View Single Post
 
Old 06-07-2015, 11:45 PM
piper7971 piper7971 is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default 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
Reply With Quote