Conditional Formatting Based on Dates-3 Columns
Closed
Hakeembeauty
Posts
6
Registration date
Wednesday September 4, 2013
Status
Member
Last seen
September 18, 2013
-
Sep 4, 2013 at 07:00 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 24, 2013 at 11:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 24, 2013 at 11:25 AM
Related:
- Conditional Formatting Based on Dates-3 Columns
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Hitman 3 free download - Download - Action and adventure
- Granny 3 download pc - Download - Horror
- Fnia 3 - Download - Adult games
4 responses
Hakeembeauty
Posts
6
Registration date
Wednesday September 4, 2013
Status
Member
Last seen
September 18, 2013
Sep 10, 2013 at 09:11 AM
Sep 10, 2013 at 09:11 AM
Hello experts, No one guided me till? Pls. help.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 10, 2013 at 11:15 AM
Sep 10, 2013 at 11:15 AM
Hi Hakeem,
Cell A5 conditional format formula's:
=AND(A5-TODAY()>10,B5="") --> Red
=AND(A5-TODAY()>=0,A5-VANDAAG()<=10,B5="") --> Green
Drag A5 down to A100 applying format only (after dragging a small square should appear with that option).
Then drag range A5:A100 one column to the right, again applying format only.
If dragging doesn't work or suit you, you can also copy and paste special and then select Format.
Best regards,
Trowa
Cell A5 conditional format formula's:
=AND(A5-TODAY()>10,B5="") --> Red
=AND(A5-TODAY()>=0,A5-VANDAAG()<=10,B5="") --> Green
Drag A5 down to A100 applying format only (after dragging a small square should appear with that option).
Then drag range A5:A100 one column to the right, again applying format only.
If dragging doesn't work or suit you, you can also copy and paste special and then select Format.
Best regards,
Trowa
Hakeembeauty
Posts
6
Registration date
Wednesday September 4, 2013
Status
Member
Last seen
September 18, 2013
Sep 11, 2013 at 04:35 AM
Sep 11, 2013 at 04:35 AM
Dear Trowa,
Thank you and I appreciate for helping but regret to say it is not meeting the requirement.
I believe you can achieve the target further as you began already.
please note the below and advise me the correct.
I went through conditional formatting>New rule>format only cell that contain>cell value>equal to>(your formula with filled colour)
The cells are coloured when the cells are blank only. While entering a date, there becomes no colour either Green or Red.
Please try again as it is a challenge for the knowledge.
Waiting for your reply.
Thank you and I appreciate for helping but regret to say it is not meeting the requirement.
I believe you can achieve the target further as you began already.
please note the below and advise me the correct.
I went through conditional formatting>New rule>format only cell that contain>cell value>equal to>(your formula with filled colour)
The cells are coloured when the cells are blank only. While entering a date, there becomes no colour either Green or Red.
Please try again as it is a challenge for the knowledge.
Waiting for your reply.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 12, 2013 at 10:22 AM
Sep 12, 2013 at 10:22 AM
Hi Hakeem,
Excel 2003 is the version I'm using, so I can't say for sure which path to follow.
You say: New rule>format only cell that contain>cell value>equal to>
But we are not looking for a cell value that is equal to something.
I think you have to use: Use a formula to determine which cell to format
I would suggest to play around with the CF options or to post another question asking how to use a formula together with CF in Excel 2010 (or later don't know which version you are using.
One last think we can try is for me to upload a file with CF. When you open the file, then hopefully the CF still works correctly and you can see how it is done.
Here is the file:
http://speedy.sh/p6jMX/Hakeem-CF-based-on-dates.xls
Curiously awaiting your reply to see how this worked out for you.
Best regards,
Trowa
Excel 2003 is the version I'm using, so I can't say for sure which path to follow.
You say: New rule>format only cell that contain>cell value>equal to>
But we are not looking for a cell value that is equal to something.
I think you have to use: Use a formula to determine which cell to format
I would suggest to play around with the CF options or to post another question asking how to use a formula together with CF in Excel 2010 (or later don't know which version you are using.
One last think we can try is for me to upload a file with CF. When you open the file, then hopefully the CF still works correctly and you can see how it is done.
Here is the file:
http://speedy.sh/p6jMX/Hakeem-CF-based-on-dates.xls
Curiously awaiting your reply to see how this worked out for you.
Best regards,
Trowa
Hakeembeauty
Posts
6
Registration date
Wednesday September 4, 2013
Status
Member
Last seen
September 18, 2013
Sep 13, 2013 at 05:59 PM
Sep 13, 2013 at 05:59 PM
Dear Trowa,
Thanks again with regret.
I tried the way you showed but it is still not working, in fact the previous way was better than tha last one, there is gave colours for cells at least when there is no entry in the cells, but here it is not at all.
for your information, I am also using EXcel 2013 only. So, I hope, it will be helpful to you too to check it all again.
I am sorry for giving you the work again and also thank you for continuously writing me.
Waiting for your feed back please.
Hakeem.
Thanks again with regret.
I tried the way you showed but it is still not working, in fact the previous way was better than tha last one, there is gave colours for cells at least when there is no entry in the cells, but here it is not at all.
for your information, I am also using EXcel 2013 only. So, I hope, it will be helpful to you too to check it all again.
I am sorry for giving you the work again and also thank you for continuously writing me.
Waiting for your feed back please.
Hakeem.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 17, 2013 at 12:01 PM
Sep 17, 2013 at 12:01 PM
Hi Hakeem,
I'm sorry to read that. I'm not sure what else I can do to help. I mean I provided the formula's for CF and provided a sample file with the CF implemented. Didn't the sample file show you anything?
Best regards,
Trowa
I'm sorry to read that. I'm not sure what else I can do to help. I mean I provided the formula's for CF and provided a sample file with the CF implemented. Didn't the sample file show you anything?
Best regards,
Trowa
Hakeembeauty
Posts
6
Registration date
Wednesday September 4, 2013
Status
Member
Last seen
September 18, 2013
Sep 18, 2013 at 01:35 AM
Sep 18, 2013 at 01:35 AM
Dear Trowa,
Thank you for the reply. Unfortunately, the file is unable to be downloaded into my system as not supporting the system (OS:2013/64 bit) will it be possible to my personal address?
waiting for your reply.pls.
Thank you for the reply. Unfortunately, the file is unable to be downloaded into my system as not supporting the system (OS:2013/64 bit) will it be possible to my personal address?
waiting for your reply.pls.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 19, 2013 at 10:36 AM
Sep 19, 2013 at 10:36 AM
Hi Hakeem,
Strange that you are not offered to convert the file. I will send you a different version this weekend since I don't think sending the same file to your e-mail will be useful.
Best regards,
Trowa
Strange that you are not offered to convert the file. I will send you a different version this weekend since I don't think sending the same file to your e-mail will be useful.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 22, 2013 at 10:57 AM
Sep 22, 2013 at 10:57 AM
Ok Hakeem, this is from Excel 2007. Hopefully it helps.
http://speedy.sh/EcW99/Hakeem-CF-based-on-dates.xlsx
http://speedy.sh/EcW99/Hakeem-CF-based-on-dates.xlsx
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 12, 2013 at 10:54 AM
Sep 12, 2013 at 10:54 AM
in addition you might find this site helpful:
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?redirectsourcepath=%252fen-us%252farticle%252fadd-change-or-clear-conditional-formats-8a1cc355-b113-41b7-a483-58460332a1af&ui=en-us&rs=en-us&ad=us#BM10
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?redirectsourcepath=%252fen-us%252farticle%252fadd-change-or-clear-conditional-formats-8a1cc355-b113-41b7-a483-58460332a1af&ui=en-us&rs=en-us&ad=us#BM10