Forum Discussion
Filter Formula to Sub Worksheets and Cell Color
I have an Excel 365 spreadsheet that I am entering data on the main master tab and then use a filter function formula to filter to 6 different sub worksheets using certain criteria. Some cells in the main master tab are colored in identifying aspects and has a conditional format we want to focus on but the colors are not filtering to the sub sheets. Is there a way to get the colors to filter also?
3 Replies
You should apply the same or similar conditional formatting rules to the sub worksheets.
That makes me sad. Maybe the next version will incorporate that feature. Thanks for help.
Formulas do not bring cell formats along with them.
