Hello Everyone!
I need a formula to add conditional formatting to change the color of cells based on the value called out in the row so that the contents of each cell can otherwise be edited.
In the example below, the header row is fixed and the contents will not change. The dates in each row of the Forecast column, however, may change. On each row, I would only like the cell highlighted in the column that corresponds with the forecasted date.
Perhaps I am overthinking this? I have been known to do that.
Thanks in advance for any help! I really appreciate it!
I need a formula to add conditional formatting to change the color of cells based on the value called out in the row so that the contents of each cell can otherwise be edited.
In the example below, the header row is fixed and the contents will not change. The dates in each row of the Forecast column, however, may change. On each row, I would only like the cell highlighted in the column that corresponds with the forecasted date.
Forecast | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | Jun-21 | Jul-21 | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 |
Jul-21 | Blue | |||||||||||
Aug-21 | Blue | | ||||||||||
May-21 | Blue | |||||||||||
Jul-21 | Blue | |||||||||||
Jan-21 | Blue | |||||||||||
Oct-21 | Blue | |||||||||||
Aug-21 | Blue |
Perhaps I am overthinking this? I have been known to do that.
Thanks in advance for any help! I really appreciate it!