13K views · 440 reactions | Need to identify cells fast? Conditional formatting to the rescue! | Microsoft Excel | Facebook

Dynamic Numbers Formatting Style in #Excel Custom Formatting of Numbers via Conditional Formatting with Option Buttons (Dynamic) | #Dashboard Add Option Buttons, Enable DEVELOPER TAB, Insert, Form Controls, Option Button and Link it with Blank Cell. Select the Columns, Go to Home Tab, Conditional Formatting, Create a New Rule, Click on Format Button then Format Cells Dialog Window, Number Tab, Custom and Write For Rs. in Thousands #,#00, For Rs. in Millions 0.00,, Apply and Make your Report Dyna