Jan 11 2021 08:36 PM
Hello All,
I am looking for a way to "Find and Replace" all the refences to a different sheet within all my conditional formatting formulas. Find and Replace worked great to change all references within the spreadsheet itself, but failed to change in all of my conditional format rules. Is there an easy way to do this other than going in and manually changing them all? I will provide an example just in case I not explaining this properly.
Old Formula =ISTEXT('SHEET 1'!$A1)
Desired Formula =ISTEXT('SHEET 2'$A1)
Basically, I am trying to highlight a range of cells based on a cell from Sheet 1, but need that changed to Sheet 2 for about 14 different rules. Does that make sense? If more clarification is needed please let me know. Thanks for any advice in advance.
Jan 12 2021 03:12 AM
I fear you'll have to edit the rules manually.
Dec 20 2023 08:49 AM
@Hans Vogelaar another example of MS falling short of what would be incredibly useful. CTRL+H works everywhere else but here :( Not aimed at you, but MS