My office has updated to Office 10 and now my conditional format which alerts me if the RO number entered is on the prior month sheet does not work any more. It will still alert me if the value is on the sheet above my input, but not the prior month sheet. I have tried to no avail to figure out the changes to make to get it working, so I'm hoping one of you Wizzards will help me!! I have attached a sample file showing what I have.
I only have 2007, but looking at the formula you have in your CF, I dont see how that is in any way liked to any sheet other than the current 1?
=COUNTIF(A$1:A2,A2)>1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
try to change the formula in CF:
=COUNTIF(January!$A$2:$A$150,$A2)>0
Thanks acerrhod! Works like a charm!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks