Hello:
I have set up my conditional formatting in my first row. I have 149 remaining rows and 12 sheets to apply the settings to. Is there a way to have excel update the remaining rows with the same formatting without having to go through each row individually.
What I have is a monthly report: July:June. I track various data on a data sheet which has all my countif's, average, averageif's and so on. So deleting the remaining sheets and just doing a copy and paste then creating a copy of the sheet isn't really an option. I also have merged cells in the row and then un-merged cells in the same row. My formula looks like this =exact($M4:M6, "4") -> applies to =$A$4:$AK:$6. I have formatting for un-merged cells which looks the same but only applies to the individual cell. At one point I was able to apply it to the entire sheet based off the one row (=exact($M4:M6, "4") -> applies to =$A$4:$AK:$423) the problem I ran into there is it ignored the un-merged cells. When I attempted to make a formula for the un- merged cells and apply it to the column the formatting didn't take effect.
Not sure what to do from here without almost starting over.
Thank you for any help/advice in advance.
Bookmarks