I have a spreadsheet of data that I would like to use conditional formatting with...essentially colour coding the cell based upon a range of data. That is easy. However...I have two sets of condition rules that I would like excel to choose from based upon data in another cell.
For example...we have data from the Fall and from the Spring. We have a set of Fall Conditions and a set of Spring Conditions. I want to have excel check Column C for either 'Fall' or 'Spring' and apply the set of conditions that are applicable. (Each set contains for ranges and assigned colour coding for the cells).
Doable?
Thank you.
For example...we have data from the Fall and from the Spring. We have a set of Fall Conditions and a set of Spring Conditions. I want to have excel check Column C for either 'Fall' or 'Spring' and apply the set of conditions that are applicable. (Each set contains for ranges and assigned colour coding for the cells).
Doable?
Thank you.