I am working a rather large project...meaning 30 plus sheets. I can use conditional formats for 5 separate variables and was curious if there is an easier or smarter way to approach this project. So i was working A vlookup but am hung up on not getting the proper results:
1) in Column A i have Date that i need to figure out the FY and I do so in Column B. I have a color legend FY22= orange FIll color
2) Can i use a Vlookup and Change the fill color in Column "A" to correspond with the color legend provided in column I.
My thinking is I will have to modify new fiscal year because for example: FY23 next year will be orange and 2027 will be added and be purple. and i will have to modify on all 30+ sheets. All sheets are the same columns just different data. So my desire is not to modify all sheets just update the FY range.