0

In Google Sheets

I have a table with numbers filled in columns A, B, C

I want to add conditional formatting:

  • If A1 = B1 = C1, highlight in same colour all cells (A1,B1,C1)
  • Apply this to the entire columns A, B, C

I can't seem to get the formula right... Can anybody help out?

Thank you!

I have tried with a few formulas like IF, AND(EXACT.., ARRAYFORMULA...

MarcoDisco
  • 1
  • 1
    Read https://stackoverflow.com/questions/20545961/conditional-formatting-based-on-another-cells-value?rq=1 – TheMaster Oct 27 '22 at 06:57

1 Answers1

1

in conditional formating select range A1:C and use custom formula:

=($A1=$B1)*($A1=$C1)
player0
  • 124,011
  • 12
  • 67
  • 124