Is there a way to get cell color formatted according to the value in the cell? I have about 900 different intensity values I would like to have represented as gray scale. Obviously, conditional formatting does not provide enough flexibility for me to get this kind of gradual change.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Heat mapping in Excel
- Thread starter Eric B
- Start date
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Actually, if you do a search for it, there have been posts for using VBA to have more than 3 conditions for conditional formatting.
Though I'm not sure how well it would work considering the amount you have...
Though I'm not sure how well it would work considering the amount you have...
Upvote
0
Similar threads
- Solved
