Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)

[ssh08trdr]

is there a way to use name ranges in conditional formatting? Thank you GOD!

[ExcelIsFun]

@ssh08trdr , sure, you can use defined names in conditional formatting formulas.

[mdc1114]

is there a way to make excel highlight a series of data in a row, based on criteria in a column. for example, i have 20 rows of data going from column A to F and i want to highlight the info in those rows, based on a number in the last column (ie. all rows containing the number 4 are going to be highlighted yellow). thanks in advance.

[ExcelIsFun]

Maybe:

Excel Magic Trick 296: Conditional Format Intersection Row & Column

[mysimonhughes]

Mike, great video, thanks.

[ExcelIsFun]

You are welcome!

[paulievegas1]

what software are you using to capture your video of PC screens (zooming in and out)?? Thanks! Love your Excel videos!!

[ExcelIsFun]

Camtasia.

[speedyhub]

Really, really cool stuff.

One question I have been struggling with - can Excel go backwards and look at cells and manipulate them based on the formatting? For example, if I manually go in and highlight cells with a yellow background, can I then sum the yellow background cells together?

I've watched about a third of the video... sorry if I missed it.

Thanks, this is great stuff!

[ExcelIsFun]

Summing by color can be done with the table feature and filter or with Custom VBA code. If you search Google there is tones of free code for summing by color. For the filter method, see this video:

Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function

[speedyhub]

@ExcelIsFun sorry for the delayed response, but I found a VBA formula that does exactly what I need. now I can say I've programmed VBA for excel! Thanks so much for your help!

[Ozzurfer]

Great video! Do you know i there's any way to save the rules that one makes in conditional formatting for later use, so that you don't have to make them over and over again?

[ExcelIsFun]

I do not. That would be cool, though.

[DrQpiano]

@ExcelIsFun -- I am such a novice and new to your work, so you may have already suggested this... so please forgive if I am insulting anyone's intelligence :-/ ....

but maybe save screenshot of formula? or type it into Notepad?

[ExcelIsFun]

You can hit stop on the video to see formula or you can download the workbook and see all the formulas!

[tamoghna9]

ExcelisFun did it once again!!!!!

[ExcelIsFun]

Thanks!

[anandvarma]

this really epic video, instead of watching the conditional formatting play list if watch this i can guarantee you, You will be expert on conditional formatting

[ExcelIsFun]

Cool! I am glad that this helps!

[dmr450]

Unconditionally a great video.

Dave

[ExcelIsFun]

Thanks Dave!!!

(Thanks funny too: "Unconditionally ")

[hamy72]

hahaha....... just when you think it cannot get better, you out do with another!.... Amazing! And what with all the workbook........ Simply Amazing!...... Thanks Mike.... if you ever get down here to the Middle East, I owe you a HUGE treat!...

[ExcelIsFun]

Thanks, hamy72!!! Now I can't wait to come and visit the Middle East!