In Google Spreadsheets, if contents of A3 match A2, I want it to turn green. Contents in cell A2 will include numbers/text.
What formula should I use in conditional formatting?
In Google Spreadsheets, if contents of A3 match A2, I want it to turn green. Contents in cell A2 will include numbers/text.
What formula should I use in conditional formatting?
Copyright © 2021 Jogjafile Inc.
A
Custom formula is
of:for
Range:
A3 should suit whether for text, numbers, a mixture (string including alphabetic character/s and digit/s), or blanks.