Forum Discussion

Jon Firooz's avatar
Jon Firooz
Copper Contributor
Nov 15, 2018
Solved

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...
Conditional Formatting
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 15, 2018

    Hi Jon,

     

    Perhaps like this

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 15, 2018

Hi Jon,

 

Perhaps like this

  • Jon Firooz's avatar
    Jon Firooz
    Copper Contributor
    Nov 15, 2018

    That is brilliantly simple!  I didn't know you could leave the min and max formulas blank.  That's a great solution, thank you!!

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 15, 2018

      You are welcome

Resources