Hi Is it possible to use find and replace to update formula within conditional Formatting. This is my example below.
=AND(OR('WC1'!$E$8=1))
The conditional formatting formula has to look at 60 sheets starting with sheet WC1, and there are lost of cells like this looking at different colums within each sheet.
I have copied and pasted the conditions to all the 60 rows where i need results but Im having to go into each condition and change the WC1 Reference to WC2, WC3 etc and its taking forever.
Can I speed this up using find and replace (Go To Special) ?
Thanks B
Bookmarks