MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Formatting or other solution?

Posted by Benji on November 14, 2001 6:56 AM

B5 is a data valiodation list with only two choices: "Yes" or "No"
A range of cells (A37:I43) in the same sheet contains text which becomes irrelevant if B5 is "No" and I want to automatically hide them if that is the case. Did a conditional formatting to make text white but it still prints black even though it is white on screen (Page is setup to print in black & white).

Is there a way to do this?

Posted by IML on November 14, 2001 7:31 AM

I can think of two possibilities.
1) Set it to print in color.
2) Wrap an if statement around your formula such as
=If(B5="YES",Original Formula or Value,"")

There is probably a flashly VBA solution if you are so inclined.
Good luck

Posted by Benji on November 14, 2001 8:21 AM

IF wrap worked fine. Thanks. NT