Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

I need a conditional formatting formula

I am trying to compare dates between two diff workbooks, workbooks New & Old.

I want a conditional formatting formula to look at the Old Sheet in A1 and compare it in the new sheet A1. If its the same date, nothing. If its a different date, then it turns red.

I am not limiting myself to the conditional formatting formula. If anyone else has ideas, feel free to post them.

I thought about linking to the old sheet on the new sheet, like AA1 and buld a formula there to return True / False comparing the two cell values. Then base my conditional formatting on that.
0
wrt1mea
Asked:
wrt1mea
  • 2
  • 2
1 Solution
 
rfportillaCommented:
Conditional formatting won't work.  Could do it with a macro, but unless this is something you are going to do often, it's not worth the time in writing and debugging.

The easiest solution would probably be to employ another sheet.  I'm assuming that you copied over the old sheet into the new sheet so that they are both available in the same workbook.  Create another sheet.  Create a formula in a1 of the new sheet that looks something like "=if(sheet1!a1=sheet2!a1,"","False").  Then drag/copy the formula to all relevant cells (cells that would be used in the other sheets).
0
 
wrt1meaAuthor Commented:
Yeah, as I started going through it, I realized CF was out the way i as trying to do it. I am using the new one and referencing the old one...

I need a couple of checks in the IF statement...trying to think out loud...
0
 
wrt1meaAuthor Commented:
Thanks for the help.
0
 
rfportillaCommented:
Anytime.  :-)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now