I'm no good with the conditional formatting formulas. See example. I thought this might work but it isn't. What i'm trying to do is make all of these cells blank through conditional formatting when cell B1 reads either FALSE or N/A (both are real options in my full spreadsheet). Can someone help me make that happen? Hopefully this is an easy one. Thanks.
Last edited by loner2003; 09-15-2010 at 09:27 AM.
FALSE is a boolean wordin Excel and doesn't need to be surrounded by quotes.
Eg... =OR($B$1=FALSE,$B$1="N/A")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You rock NBVC. Fixed. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks