Conditional Formatting

[GalileoG]

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.

 

[IRstuff]

The actual spreadsheet might be useful, don't you think?

TTFN

FAQ731-376
Chinese prisoner wins Nobel Peace Prize

 

[electricpete]

Attached is a demo of hiding cells using conditional formatting based on result of if( ) statement in another cell (Formula).

This is done in Excel 2003 and is pretty simple to do. Maybe they made life difficult in later versions?

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

 

[Ziggypump]

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

 

[IDS]

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/

 

[GalileoG]

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.

 

[IDS]

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/

 

[electricpete]

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)' ?