Excel: Conditional Formatting

This video includes information on:
• Understanding conditional formatting
• Creating a conditional formatting rule
• Using preset conditional formatting
• Removing conditional formatting

We hope you enjoy!

[seanward]

This was a great video, short and sweet and explained succinctly what conditional formatting is and how you can apply it to something your doing within excel. Thank you for the video.

[raginipant]

Probably the best computer learning channel on YouTube

[paulpickett]

Exactly what I was looking to learn and a very efficient presentation. Thanks, mate!

[HernandezIvan]

Thank you for being so clear and quickly getting to the point!

[syedabeer]

Clear.... simple and understandable.... great job thanks a cheers!

[fernandezlagarita]

Very useful ! Straight to the point!! Thanks from Costa Rica!!

[TahaMuzaffar]

BEst Explanation within less time, THANKS

[angeloters]

the best vid ever for explaining this subject thank you a lot.

[abraham]

Can you format a whole row based on one cell?

[DDRR]

thanks for the nice video!! i subscribed

[sash]

very clearly understood. Thanks a lot!

[enricopunta]

Hi, I have a rather difficult question: I got a file Excel with activation macro. I use many conditional formatting and I wish that the interval of application would remain unchanged. I think that the problem are the macros but I obtain no effect registering a macro and setting the conditional formatting. Do you have you any ideas? Thanks

[Savere]

How do you highlight a particular number or word in a specific color? I just want to highlight the number 01 in all my cells to orange. How do you do that? I tried it this way with conditional format and it makes the entire cell orange not the number.

[Crissy-etjo]

Hello, can someone please tell me how I can add formatting rules to a column of cells so that my price is always displayed rounder to the first decimal places eg 10.5 and not 10.46. Thanks in advance!!

[SuperDude]

Anyone having a problem with highlight cells rules (0:57) try this without the symbol ($4000 => 4000).

[pasindudinusha]

What if I want to highlight salespersons which have achieved more than 4000 sales??

[maximoco]

Very interesting video. I have tried to add rule in Conditional formatting, and using the excel online this feature does not show on the drop down list. Can anyone advise?  I would assume that this feature is not enabled on the online version.

[dragoda]

Hello, how can I color several random numbers from a series, like, i want all numbers 7 48 25 32 17 to be red. and then again, other numbers in other colors, blue for numbers 4, 16, 19 without having the need to set a new rule for each number, like 7 red, go again and set rule for 48, etc. Thx

[shakeboi]

What if u want to format that = to 2 or more numbers say 1000 and 5000 exaclty

[drinkmilkmakedickstrong]

sorry about my pic my friend and i like to change it while we do italian work but anyway amazing, thank you for making this vid this will definitely help in my work (and between you and me get better grades than the others) *coughs multiple times* yep ok so g'bye... also sub to my channel ill chaneg the pic back now!!