Hi,
My understanding is that conditional formatting doesn't work across worksheets. Therefore what I would like to do is create a Macro to do the following:
If a number (e.g. 12345) is typed in column A on worksheet A and it is the same as a number already in column B on worksheet B, then that cell in worksheet A turns Blue.
Is this doable?
Thanks for your help.
Hello Gaztr1x,
Not sure where you heard that but it isn't true. Set the conditional formatting rule to: Format values where the formula is true.
Use this formula: =MATCH(A1,"Sheet2"!B:B,0) and select the color you want the cell to be when the condition is met.
Change A1 to match the cell the conditional formatting is applied to.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
Thanks for that I will give it a try. I read somewhere that in 2007, CF wouldn't work across worksheets. It is good to know that this is possible.
I found another work around where I created an extra column with a duplicate finding formula. Then applied a conditional format to it.
Thanks again for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks