Conditional formatting in Sheets rows based on text in cell
Closed
Lindsey
-
7 Mar 2022 à 12:30
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 7 Mar 2022 à 18:23
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 7 Mar 2022 à 18:23
Related:
- Excel conditional formatting row based on cell text
- Excel conditional formatting based on date - Guide
- Excel clear formatting - Guide
- Conditional formatting based on another cell text - Excel Forum
- Excel add 1 if cell contains text ✓ - Excel Forum
- Saints row 2 cheats - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
7 Mar 2022 à 18:23
7 Mar 2022 à 18:23
Lindsey, Good evening.
To solve this specific question try to do:
------------------------------------------------------------------
• Select B1, D1...to...G1
• Conditional Format > Formula
• Type -->
• 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
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
