Conditional formatting in Sheets rows based on text in cell

Lindsey - Mar 7, 2022 at 12:30 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Mar 7, 2022 at 06:23 PM
Hello,
I have looked through some past answers and have not found a solution yet; I am trying to apply conditional formatting to a sheet where if text in column A = a specific name, different cells in that row will highlight.
For example,
if the name Abbott is entered into column A, I would like column B, D, E, F, G in that row to highlight green to notify that an entry is required is those specific cells.
Thanks in advance for any help!





System Configuration: Windows / Chrome 99.0.4844.51

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Mar 7, 2022 at 06:23 PM
Lindsey, Good evening.

To solve this specific question try to do:
------------------------------------------------------------------
• Select B1, D1...to...G1

• Conditional Format > Formula

• Type -->
=$A1="Abbott"


• Format --> Select FILL as GREEN

OK
------------------------------------------------------------------
Possibly you will have to adapt this formula to meet your real need and not just this example you provided us.

Was this what you wanted?

Hope this helps
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
0