Create a Heat Map using Conditional Formatting in Excel

[@partheshshanbhag6362]

Very well explained. To the point and perfect. Thank you.

[@Computergaga]

My pleasure. Thank you Parthesh.

[@bhuvanasp7256]

Thank you for clear explaination

[@Computergaga]

You are welcome

[@jumbojaberi]

Is there way to apply 3 scale conditional formatting to odd cells only or even cells only of a range?

[@Computergaga]

Sure, but not with the Color Scales feature I do not believe. We could do it by creating three separate rules (one for each colour). We could include the condition such as

[@irshadmirasa9289]

Thank you very much for the new lesson.

[@Computergaga]

Your welcome Irshad

[@tropicalforestmanagement3426]

Thanks. Very much useful.....

[@Computergaga]

Excellent!

[@jeetsarkar1989]

Thank you, it helped

[@Computergaga]

Excellent! Thank you, Jeet.

[@rs-tarxvfz]

Thank you SOOO much !!

[@Computergaga]

You're very welcome 😊

[@mysteriousbella6878]

Great video! Thanks.

[@Computergaga]

Thank you 😊

[@teckietercermundista546]

is there a way to do it directly in a pivot that keep working after filtering a town for example

[@SanjayKumar-yx6gc]

Thank you so much. We want more interesting examples of conditional formatting in your coming video.

[@Computergaga]

Not a problem, Thanks Sanjay.

[@RuleFox]

Hi, is there a way of adding a legend to identify what each allocated colour should represent?

[@Computergaga]

There is not a setting for this. It would need to be added manually by formatting a cell in that colour and typing what it represents beside it.

[@RuleFox]

@@Computergaga OK, thank you.

[@lukereiner]

I love the accent, man

[@Computergaga]

Thank you Luke.

[@ArronsAdventures]

Thanks for the video. I just have one question: Do you know how to use the heatmap on other cells that display a different value? For example on sheet one I have a row of 4 different numbers (For example: 2, 5, 6. 3) and I can make the heatmap there using conditional formatting with red being 0 (under target), yellow being 6 (on target) and green being anything higher than 6 (over target). But my problem is that I want to make a heat map on sheet two (related to sheet one) but if I use the same conditional formatting on sheet one with sheet two, the row of 4 which all display the number 6 will just show as yellow which is incorrect. I'm hoping you can help! thanks.

[@freeetrialll4996]

Has anyone told you that you sound like bear grylls.

[@Computergaga]

Don't think so. But I'll take it 😊