Conditional formatting in Sheets rows based on text in cell
Closed
Lindsey
-
Mar 7, 2022 at 12:30 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 7, 2022 at 06:23 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 7, 2022 at 06:23 PM
Related:
- Conditional formatting in Sheets rows based on text in cell
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 7, 2022 at 06:23 PM
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 -->
• 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
