Excel 2010 - Conditional Formatting - Formulas

A tutorial showing how to use formulas to trigger conditional formatting in Excel 2010

[pandharinathjoshi]

Good to see sir.. nice video
Sir make office 365 new formulas sir

[foxrivers]

Interesting alternative to formatting alternate rows, as I only know how to do that using tables.

[chandankumarmishra]

I WAS LOOKING FOR LONG TIME, VERY USEFUL
THANK YOU VERY MUCH

[malthus]

How do I use Icon Sets with a formula? ie, IF cell 1 is greater than cell 2, put in a green up arrow? Thanks.

[bluhaws]

Great video! What did you use for your Screen capture?

[raztastic]

hello thanks for your tutorial. i need your help please. i work on a project that i scan an item that adds the item number to excel. the item number begins with 000 eg 0003424, some items just have two zeros eg 003424. how do i get excel to add the missing or extra zero to all items. for example when i scan an item with 2 zeros it automaticaully add the 3rd zero. i will be very grateful for your help. thank you

[martinesse]

how could i highlight names instead of salaries but apply the same rules?

[ravijhamb]

Hi

The video is fade into some duration/part. I'm unable to get your written formula.

Kindly use right recording tools.

[ZafarIqbal-ocpt]

IF COLUMN CONTAIN PAS & FAIL I NEED BESIDE COLUMN PAS=OK & FAIL=NO AUTOMATICALLY. HOW?

[adiletyessaliyev]

is there anyone who really knows excel and can explain how to format cells based on their own values with three color format style using "If " logical condition?! I'm really tired of the shit that everyone is trying to promote as excel master class (sorry about that)