|
|
#1
06-07-2015, 11:45 PM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows Vista 
Office 2007
Threaded Mode