Nick Green of http://EchoXL.com shows you how he uses conditional formatting to create a clean looking worksheet for his users.
What He Does
Nick uses toggle buttons to select different features on his graphs. Â As the toggle buttons are selected, text that is no longer relevant seems to disappear from the spreadsheet. Â Nich uses Conditional formatting so that as the toggle is selected, the text color is changed to white. Â Tis causes it to blend with the background.
This is a good tip to create a clean environment for your end-user.
What’s Next?
Leave a message or question for Nick in the comments section below. Â Also hit one of the social sharing buttons to share this with the world.