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:
- How would you change all cells containing the word pass to green
- Excel if cell color is green then - Best answers
- Excel formula to change cell color without conditional formatting - Best answers
- Word apk for pc - Download - Word processors
- Word watermark on all pages - Guide
- Number to text in word - Guide
- How to change free fire facebook account to google account - Guide
- Tamil pdf to word ✓ - Word Forum
1 response
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