Forum Discussion
Excel 3-color scale based on dynamic data
Hi, I have a spreadsheet that includes a date column. What I would like is to figure out a way to use Excel's 3 color scale so the date furthest back is shaded color 1, today is color 2, and the...
Hi Jon,
Perhaps like this
Hi Jon,
Perhaps like this
That is brilliantly simple! I didn't know you could leave the min and max formulas blank. That's a great solution, thank you!!
You are welcome
