![]() |
|
#1
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting | grexcelman | Excel | 8 | 01-12-2015 10:27 AM |
| Conditional Formatting | sdfrance | Excel | 3 | 01-06-2015 07:10 AM |
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
Conditional Formatting
|
namedujour | Excel | 3 | 08-25-2011 01:46 PM |