Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Could you please specify any situation you have applied conditional formatting in ms excel for your business analysis?

have you achieved your job goal by applying conditional formatting in MS Excel?

user-image
Question ajoutée par Muhammed Muzammil , Assets & CAFM Lead , Serco (Riyadh International Airports)
Date de publication: 2013/09/29
Mohamed Elkharashy
par Mohamed Elkharashy , Production Planning Engineer , Amiantit

Yes

-Applying data bar gives an indication of cell value

 

Mohsin Ali
par Mohsin Ali , Product Manager-Branch-less Banking , Bank Alfalah

Conditional Formatting can be used for:

  1. Identifying duplicate records
  2. data bars
  3. Highliting values as per your requirment e.g values greater than less thay or equal to

Last I would say it's more of a presentation tool and definatly it can make your work look better and effective.

Azharuddin Mohammed Khaja
par Azharuddin Mohammed Khaja , FINANCE & ADMINISTRATION EXECUTIVE , AIN CORPORATION SECURITY SOLUTIONS INDIA PVT LTD

Happened to use it several times, whether it be during studies or whilst on job. If I take it on a border prospective, I used it to mark out negative values, denote units/price/headcount out in a particular range, out of a huge statistical data-highlight useful or underrated or over rated values, particular employee and his concerned details, duplicate values, useful in marketing to bifurcate particular customers/clients and etc.

Muhammad Aazaath Uthmalebbe
par Muhammad Aazaath Uthmalebbe , Senior IT Administrator , Al Jaber and Makhlouf

Eg: If You want to Identify low Salary range of employees from your company  Excel Database you can use this conditional formatting after that its will highlighted the employees as customization color you choose from conditional formatting option. 

"Situation : less than $1500 Salary getting Employees."

Hossam AL-Den Ahmed Khaled ghanem
par Hossam AL-Den Ahmed Khaled ghanem , manager , shouman

yes ,on check reports to show the important result

Muhammad Farhan Qamar CPA
par Muhammad Farhan Qamar CPA , Group Finance Manager , Al Khafrah Holding Company

I used it several times. In one instance, I was building a master data template and used the Conditional Formatting to highlight the duplicate cells. In other case, I found it useful to highlight the negative numbers.

More Questions Like This