#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Quote:
Also perhaps post a small sample sheet showing what you want to achieve?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I want to use the conditional formatting so that if any of the cells E5 to I5 in worksheet 1 has something (the person needs to mark one of the cells) and the F5 in worksheet 2 is less that 69% then the cell E5 in worksheet 2 change to red, but if in any of the cells E5 to I5 has something (the person marked one) but F5 is more that 69% the nothing happens.
so it will be something like this (it's not a formula I am trying to write in excel language so you understand) if E5<>"", F5<>"", G5<>"", H5<>"", I5<>"" IN WORKSHEET1 AND IF F5>69% IN WORKSHEET2 THEN E5 IN WORKSHEET 2 CHANGE TO RED THANKS! |
#4
|
||||
|
||||
Quote:
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
the person will at least have to put something in one of the cells
|
#6
|
||||
|
||||
I meant this
Quote:
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
Ohh! I have no idea how to post it since the document has lost of pages.
|
#8
|
||||
|
||||
Just make something up, doesn't have to be very large.
To post click " go advanced" then " manage attachments" and follow the wizard
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#9
|
|||
|
|||
Ok I uploaded a dummy to see if you understand
|
#10
|
||||
|
||||
Like this? ( see attached)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#11
|
|||
|
|||
yeessssss!!!!!! thanks, thanks thanks!
How do I posted solved? |
#12
|
||||
|
||||
Click "thread tools" in the upper part of the page then " mark thread solved"
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |