conditional formattinggoogle sheets
I am trying to create a custom formula for conditional formatting. I want to highlight the cell if the text appears in a list of names. This list will contain 210 unique names so I can't type each one of those into the formula. I am hoping I can reference a list, but can't seem to find a example for Google Sheets. I was able to see an example for excel that would reference a "List" you would create.
Thanks,
Noel
You can use a range as a parameter for the ISFORMULA() function.
e.g. If you want to highlight all cells containing formulas in the range A1:J10, then you can use the formula =ISFORMULA(A1:J10) and apply it to the range A1:J10.
Note that this works with normal ranges (e.g. B2:F30), but not with infinite ranges (e.g. B:F).
conditional formatting can't intake a cross-sheet reference without INDIRECT therefore try:
=COUNTIF(INDIRECT("Sheet1!A1:A"), A1)=1and from there you can build an array:
=COUNTIF({INDIRECT("Sheet1!A1:A");
INDIRECT("Sheet2!A1:A");
INDIRECT("Sheet3!A1:A")}, A1)=1
Best Answer
All duplicate values highlighted in both columns is achieved using:
D3:D27:=COUNTIF($A$3:$A,D3)A3:A27:=COUNTIF($D$3:$D,A3)First approach
I believe the formula you need is as simple as:
=$A1="Roman"