1. I am wondering if Conditional Formatting by formula can be copied like a formula can to multiple cells.
The reason I ask is...
2. I have conditional formatting to strikethrough a cell in SheetA when it equals another value in SheetA I also have a master list of all possible options in SheetB. What I would like to do is when a cell has disqualified and has a strikethrough in SheetA, it would also do it in SheetB to keep from having to duplicate work. It doesn't have to be copied conditional formatting but if that function could work, that would be great.
Not sure if this works but not sure how else do to that.
The reason I ask is...
2. I have conditional formatting to strikethrough a cell in SheetA when it equals another value in SheetA I also have a master list of all possible options in SheetB. What I would like to do is when a cell has disqualified and has a strikethrough in SheetA, it would also do it in SheetB to keep from having to duplicate work. It doesn't have to be copied conditional formatting but if that function could work, that would be great.
Not sure if this works but not sure how else do to that.