Have cells inherit background color
So, I have a helper sheet that tracks Budgeted, Committed and Actual spend for an individual project based on the end date from a project sheet. The sheet is laid out where a total of 24 months have their own columns in chronological order from left to right. There are four rows for Budgeted, Committed, Actual and the last uses a formula to determine what data to display depending on the contents of the other three. We'll call this row Color.
What I want to happen is for the background color of each cell in the color row to change based on if it used data from the Budgeted, Committed or Actual row. All the solutions I've seen use conditional formatting ,which I can't get to work, or helper columns, which I'd like to avoid because I'd need so many.
Any help is appreciated.