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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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?
__________________
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
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
if E5<>"", F5<>"", G5<>"", H5<>"", I5<>"" IN WORKSHEET1
You mean that EACH cell contains something?
__________________
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
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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?
__________________
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
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
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, 7 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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Like this? ( see attached)
Attached Files
File Type: xlsx Copy of dummy.xlsx (18.4 KB, 8 views)
__________________
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
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:00 AM.


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