Hello everyone, I'm trying to have conditional formatting to work for a large data set, i've got 70 areas and 52 weeks to look for.
here is a shorter version of the data that I'm working with
I have multiple worksheets with the same name as the first two words from the area column like this: Area 1_data, Area 2_data, etc..
i would like conditional formatting to look for the week number in the worksheet that has the first two words and "_data" in the column D and if it finds the number "2" for example it colors the cell green otherwise nothing
is it possible without having to do it all manually?
thank you in advance for looking at it
here is a shorter version of the data that I'm working with
area ↓ week-> | 2 | 4 | 6 | 8 | 10 |
Area 1 apple | |||||
Area 2 berry | |||||
Area 3 orange | |||||
Area 4 banana |
I have multiple worksheets with the same name as the first two words from the area column like this: Area 1_data, Area 2_data, etc..
i would like conditional formatting to look for the week number in the worksheet that has the first two words and "_data" in the column D and if it finds the number "2" for example it colors the cell green otherwise nothing
is it possible without having to do it all manually?
thank you in advance for looking at it