Jun 29 2021 07:25 PM
I have two worksheets and I am trying to work out if there is a way to say that if a number is worksheet A is also in worksheet B - can it be highlighted green?
Jun 29 2021 11:38 PM
You could define a named formula 'format?' that refers to
= COUNTIFS(LookupRange, currentCell)
where LookupRange is a range on the other sheet and currentCell is a relative reference to the active cell. Use on the worksheet will generate circular references but within conditional formats it is OK.