CF using date to change Font/Backgroundcolor to another cell
Closed
edz
-
Jul 9, 2017 at 06:24 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 9, 2017 at 03:30 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 9, 2017 at 03:30 PM
Related:
- CF using date to change Font/Backgroundcolor to another cell
- How to change idm language - Guide
- How to change date format in excel to mm/dd/yyyy - Guide
- Netflix subtitle font - Guide
- How to change account based in instagram - Instagram Forum
- How to change your best friends list on snapchat to 3 - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 9, 2017 at 03:30 PM
Jul 9, 2017 at 03:30 PM
edz, Good afternoon.
Try to do:
a) Select B1
b) Conditional Format --> Using formula
--> =MONTH(A1)=5
--> Format: Font/Fill color to desired font/bakground color
OK
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to do:
a) Select B1
b) Conditional Format --> Using formula
--> =MONTH(A1)=5
--> Format: Font/Fill color to desired font/bakground color
OK
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão