Condition formatting on changing cell color based on another cel
Closed
Saitoh7
Posts
1
Registration date
Friday July 17, 2015
Status
Member
Last seen
July 17, 2015
-
Jul 17, 2015 at 12:44 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 17, 2015 at 03:04 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 17, 2015 at 03:04 PM
Related:
- Excel formula to change cell color without conditional formatting
- How would you change all cells containing the word pass to green - Best answers
- Excel if cell color is green then - Best answers
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- How to change date format in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
- Conditional format based on another cell containing text - Excel Forum
1 reply
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 17, 2015 at 03:04 PM
Jul 17, 2015 at 03:04 PM
Saitoh7, Good afternoon.
Try to do:
Select A2.
Menu Conditional Format
Formula
Rule 1
=A1="PASS"
Format as GREEN
Rule 2
=A1="FAIL"
Format as RED
OK
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to do:
Select A2.
Menu Conditional Format
Formula
Rule 1
=A1="PASS"
Format as GREEN
Rule 2
=A1="FAIL"
Format as RED
OK
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão