Hi Guys,
I am looking for some help, I have a spreadsheet which is essentially a survey and using a drop down there are 5 available values. This would be filled in by 2 different people and a 3rd column would do a comparision and highlight in either 'Green' for a match and 'Red' for a non match.
How do i do this?
Thanks for the help in advance.
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND(A2<>"",A2=B2) format fill GREEN
Repeat 3 and for with =AND(A2<>"",A2<>B2) format fill RED
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
Hi Ford thanks for reply, apologies but i cant get this to work. I presume its me understanding your answer. I have added an attachment that showswhat i am working with you you be able to show me on excel how the code looks.
Really appricate the help
sample file 1234.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks