Turn On Conditional Formatting

Today's topic is really mind blowing for all the Excel Lovers. And, I also hope there will be lots of comments to this post too. The reason is ...

I am sorry, if you are thinking "Shit! come on man, tell me what is the topic for today, give the topic".

The topic for today is how to apply Conditional Formatting to the set of data just by clicking on the button.

...

To do this we have to follow two tricks.

TRICK 1:

Turn on Conditional Formatting using HOME-->STYLES-->Conditional Formatting-->TOP/BOTTOM CELLS-->TOP 10 ITEMS--> Click on OK to close the window.

TRICK 2:

Turn on Conditional Formatting using HOME-->STYLES-->Conditional Formatting-->NEW RULE-->Use a formula to determine which cells to format and enter this formula

=if($A$4=TRUE,FALSE,TRUE)

or

=A4=FALSE

both works the same way however, the first one looks like an elegant way of doing this job done for your bosses.

Note: This formula works if cell A4 is TRUE then CF will be on else (FALSE) CF will be off

FINAL TOUCH:

Two things has to do here,

1. GoTo DEVELOPER tab--> Controls Group -->Click on Insert --> select Check box icon and drag on the cell to display the check box on Excel and adjust to the cell width to create good impression to your boSSSSSS. :)

1.a) Right click on the Check Box and GoTo FormatControl --> you can adjust colors and lines from first tab, uncheck Lock text from protection tab to change the custom name (here it is "Turn CF ON", Cell link as $A$4 in Control tab and click on OK to close the window.

2. The second and the last one is, GoTo Conditional Formatting --> Manage Rules --> Select "This Workbook" -->Check mark "Stop if TRUE" for Formula --> Click on APPLY and OK