Conditional formatting

Copper Contributor

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?

1 Reply

@bianca2089 

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.

 

image.png