I am trying to highlight (cell format) a series of cells per row after the active month (Column "U1") that has a value (numerical or text). The highlight color will vary upon the drop-down selection in (Column "E").
The caveat is that I need every month previous to the active month will be changed to a grey-white gradient background.
Here is a sheet Example to help you follow what I am talking about.
Thanks,
Scott
The caveat is that I need every month previous to the active month will be changed to a grey-white gradient background.
Here is a sheet Example to help you follow what I am talking about.
Thanks,
Scott