×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Conditional Formatting

Conditional Formatting

Conditional Formatting

(OP)
Conditional Formatting - I can't get it working right

I have an IF statement, when this IF statement is true, I would like the paragraph below to disappear.

Under conditional formatting rules, I am using 'Use a formula to determine which cells to format' and I select the cell which contains the IF statement. I then choose white font colour and a white background for the paragraph below (that I would like to hide when the IF statement is true.)

Seems fairly straight forward, but it's not working. The paragraph below will not turn white regardless of whether the IF statement is true or false.

What am I doing wrong? I am using Excel 2007. Thank you for your help.
 

RE: Conditional Formatting

What's the problem.  It seems to work the way you want it to work, only backwards.

RE: Conditional Formatting

Select the cell or range where you want the formatting to apply.
Click the Conditional Formatting icon
Select New Rule ...
Select Use a formula to determine which cell to format
In the Format values where this formula is true box, select the cell with the formula in it.
Click the format button and select your format
Click OK

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Conditional Formatting

(OP)
Thank you all for the responses.

I found my problem. The output from my IF statement has to contain the exact word 'TRUE'. I initially thought that the 'use equation' function of conditional formatting requires that the IF statement be true as opposed to outputting the word "TRUE." It works perfect now. Thanks again.

 

RE: Conditional Formatting

You don't actually need an If statement.  For instance:

=B2>0

will return TRUE if B2 contains a positive number, or FALSE for anything else.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Conditional Formatting

Quote (Ziggypump):

What's the problem.  It seems to work the way you want it to work, only backwards.  
I'm not sure what you're referring to.  But since mine was the only spreadsheet posted, I'm guessing you're referring to my spreadsheet?
In that case you should note that there's nothing backwards about it - it does exactly what the text indicates.

Sorry if I misunderstood your meaning.
 

=====================================
(2B)+(2B)'  ?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources