My initial effort was to create a formula that would autofill a cell with the same color from another cell. However, all the research I've done says it's not possible without a VB formula. So I've been searching for a formula to enter into Conditional Formatting that would look at cell AC5 and if the date in that cell is >=03/01/2018 and <=05/31/2018, then it would color fill cells AD5 & AE5 with a certain color. I've already got AC5 with it's own conditional format to color one of four colors based on date ranges. However, I need the adjacent cells, AD5, AE5, to be the same color as AC5 also. AD5 and AE5 contain different data and their color it dependent upon AC5.
I'm just going in circles trying everything I read. Help/suggestions are much appreciated!
Bookmarks