Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-07-2015, 11:45 PM
piper7971 piper7971 is offline Help with if and conditional formatting Windows Vista Help with if and conditional formatting Office 2007
Advanced Beginner
Help with if and conditional formatting
 
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
  #2  
Old 06-08-2015, 03:21 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with if and conditional formatting Windows 7 64bit Help with if and conditional formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Quote:
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.
Could you please explain a bit more please, your requirements are rather confusing.

Also perhaps post a small sample sheet showing what you want to achieve?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 06-08-2015, 07:19 AM
piper7971 piper7971 is offline Help with if and conditional formatting Windows Vista Help with if and conditional formatting Office 2007
Advanced Beginner
Help with if and conditional formatting
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 06-08-2015, 09:10 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with if and conditional formatting Windows 7 64bit Help with if and conditional formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Quote:
if E5<>"", F5<>"", G5<>"", H5<>"", I5<>"" IN WORKSHEET1
You mean that EACH cell contains something?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #5  
Old 06-08-2015, 10:20 AM
piper7971 piper7971 is offline Help with if and conditional formatting Windows Vista Help with if and conditional formatting Office 2007
Advanced Beginner
Help with if and conditional formatting
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

the person will at least have to put something in one of the cells
Reply With Quote
  #6  
Old 06-08-2015, 11:37 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with if and conditional formatting Windows 7 64bit Help with if and conditional formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

I meant this
Quote:
if E5<>"", F5<>"", G5<>"", H5<>"", I5<>"" IN WORKSHEET1
AND IF F5>69% IN WORKSHEET2
THEN E5 IN WORKSHEET 2 CHANGE TO RED
Could you please post a sample sheet with some mock-up data and expected results?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #7  
Old 06-08-2015, 12:24 PM
piper7971 piper7971 is offline Help with if and conditional formatting Windows Vista Help with if and conditional formatting Office 2007
Advanced Beginner
Help with if and conditional formatting
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

Ohh! I have no idea how to post it since the document has lost of pages.
Reply With Quote
  #8  
Old 06-09-2015, 12:02 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with if and conditional formatting Windows 7 64bit Help with if and conditional formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Just make something up, doesn't have to be very large.
To post click " go advanced" then " manage attachments" and follow the wizard
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #9  
Old 06-09-2015, 10:49 AM
piper7971 piper7971 is offline Help with if and conditional formatting Windows Vista Help with if and conditional formatting Office 2007
Advanced Beginner
Help with if and conditional formatting
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

Ok I uploaded a dummy to see if you understand
Attached Files
File Type: xlsx dummy.xlsx (17.7 KB, 1 views)
Reply With Quote
  #10  
Old 06-09-2015, 12:11 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with if and conditional formatting Windows 7 64bit Help with if and conditional formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Like this? ( see attached)
Attached Files
File Type: xlsx Copy of dummy.xlsx (18.4 KB, 2 views)
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #11  
Old 06-09-2015, 03:41 PM
piper7971 piper7971 is offline Help with if and conditional formatting Windows Vista Help with if and conditional formatting Office 2007
Advanced Beginner
Help with if and conditional formatting
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

yeessssss!!!!!! thanks, thanks thanks!

How do I posted solved?
Reply With Quote
  #12  
Old 06-10-2015, 12:07 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with if and conditional formatting Windows 7 64bit Help with if and conditional formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Click "thread tools" in the upper part of the page then " mark thread solved"
__________________
Please note I am not active on this forum anymore
Reply With Quote
Reply

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
Help with if and conditional formatting Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Help with if and conditional formatting Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM


All times are GMT -7. The time now is 01:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft