Conditional Formatting
Closed
gupanjali
Posts
1
Registration date
Monday September 9, 2013
Status
Member
Last seen
September 9, 2013
-
Sep 9, 2013 at 07:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 10, 2013 at 10:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 10, 2013 at 10:34 AM
Related:
- Conditional Formatting
- Excel formula to change cell color without conditional formatting - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- How to clear formatting in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Sep 10, 2013 at 10:34 AM
Sep 10, 2013 at 10:34 AM
Hi Gupanjali,
Give these formula's a try:
=MID(A1,4,1) to determine the last digit of the year.
=RIGHT(A1,2) to determine the week of the year.
Best regards,
Trowa
Give these formula's a try:
=MID(A1,4,1) to determine the last digit of the year.
=RIGHT(A1,2) to determine the week of the year.
Best regards,
Trowa