How to create several rules to change a cell's format.
Closed
Eaqj
-
Oct 28, 2016 at 03:56 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 28, 2016 at 07:16 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 28, 2016 at 07:16 AM
Related:
- How to create several rules to change a cell's format.
- How to change date format in excel - Guide
- How to create @ in laptop - Guide
- Create skype account with gmail - Guide
- How to change whatsapp time format - Guide
- How to change free fire facebook account to google account - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 28, 2016 at 07:16 AM
Oct 28, 2016 at 07:16 AM
eaqj, Good morning.
The Conditional Formatting will do this task for you.
Try to use:
Select H4
Conditional Format Menu --> Using Formula
Rule 1
=I4="Paid"
Format:Fill Color GREEN
OK
Rule 2
=AND(I4="PENDING", H4>=TODAY())
Format:Fill Color ORANGE
OK
Rule 1
=AND(I4="PENDING", H4<TODAY())
Format:Fill Color RED
OK
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
The Conditional Formatting will do this task for you.
Try to use:
Select H4
Conditional Format Menu --> Using Formula
Rule 1
=I4="Paid"
Format:Fill Color GREEN
OK
Rule 2
=AND(I4="PENDING", H4>=TODAY())
Format:Fill Color ORANGE
OK
Rule 1
=AND(I4="PENDING", H4<TODAY())
Format:Fill Color RED
OK
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão