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.
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
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize
RE: Conditional Formatting
This is done in Excel 2003 and is pretty simple to do. Maybe they made life difficult in later versions?
=====================================
(2B)+(2B)' ?
RE: Conditional Formatting
RE: Conditional Formatting
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
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
=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
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)' ?