Conditional Formatting Based On Changing Dates
Solved/Closed
SpaceMonkees
Posts
7
Registration date
Wednesday July 31, 2013
Status
Member
Last seen
December 2, 2013
-
Jul 31, 2013 at 12:41 PM
SpaceMonkees Posts 7 Registration date Wednesday July 31, 2013 Status Member Last seen December 2, 2013 - Aug 5, 2013 at 07:53 AM
SpaceMonkees Posts 7 Registration date Wednesday July 31, 2013 Status Member Last seen December 2, 2013 - Aug 5, 2013 at 07:53 AM
Related:
- Conditional Formatting Based On Changing Dates
- Instagram account based in wrong country - Instagram Forum
- How to change number of best friends on snapchat - Guide
- Clear formatting in excel - Guide
- Based on the values in cells b77 b81 c77 - Excel Forum
- How to change time on whatsapp - Guide
4 responses
russp5
Posts
4
Registration date
Friday August 2, 2013
Status
Member
Last seen
August 2, 2013
1
Aug 2, 2013 at 01:18 PM
Aug 2, 2013 at 01:18 PM
In column C you can create a formula to check if cells on column A and B are the same:
=IF(A1=B1,TRUE,FALSE)
Now you can create the conditional formatting on that column to highlight changes.
=IF(A1=B1,TRUE,FALSE)
Now you can create the conditional formatting on that column to highlight changes.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 1, 2013 at 11:20 AM
Aug 1, 2013 at 11:20 AM
Hi SpaceMonkees,
Set conditional format for row 1, drag the formatted cells down, and select format only from the options square that appears when you are done dragging.
Best regards,
Trowa
Set conditional format for row 1, drag the formatted cells down, and select format only from the options square that appears when you are done dragging.
Best regards,
Trowa
SpaceMonkees
Posts
7
Registration date
Wednesday July 31, 2013
Status
Member
Last seen
December 2, 2013
Aug 2, 2013 at 11:27 AM
Aug 2, 2013 at 11:27 AM
No unfortunately that doesn't work as it still checks for duplicate cells within the selected cells.
i.e B1 & B10 are the same date so has highlighted them as duplicates, but i want it to only check B1 against A1, B10 against A10.
Thanks for answering though! Any other thoughts?
i.e B1 & B10 are the same date so has highlighted them as duplicates, but i want it to only check B1 against A1, B10 against A10.
Thanks for answering though! Any other thoughts?
SpaceMonkees
Posts
7
Registration date
Wednesday July 31, 2013
Status
Member
Last seen
December 2, 2013
Aug 5, 2013 at 07:53 AM
Aug 5, 2013 at 07:53 AM
I knew I was over complicating things!
Thanks Russp5 - its certainly a work around so just need to tweak it to make it work well within my sheet.
Thanks Russp5 - its certainly a work around so just need to tweak it to make it work well within my sheet.