Register now or log in to join your professional community.
Let's say I have a dataset, a table with day-names and day-hours and some values filling the table.
How would you automatically colour cells to look like a heat map, colours gradually going from Red to Green (for example) where Red is bad value and Green is good?
This question just to see if different people have different solutions, I know the answer ;)
you just name the process with it's real name.
It is heat map Excel
1. select you data
2. use conditional formatting
3. Choose the colors you want (red and green in your case)
4. pay attention to the logic order of the colors you want.
done
makes sense? hope
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.