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?