I am creating an Excel 2007 spreadsheet which contains one worksheet in which to enter data, and another worksheet that uses 'LOOKUP' based on the data entered. Whilst it successfully finds the correct value, the values on the second worksheet are colour coded (by the cells being filled in with a colour). Is there a way for the LOOKUP formula to also return the colour with the value to the 1st worksheet?
I hope that question makes sense?
Not with the base Excel functions. This would be possible with VBA at the extreme, but could you possibly use conditional formatting? If the color coding follows a pattern, it may be useful.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Thank you Pauleyb - I was afraid this would be the answer. Sadly the colour coding follows no logical pattern, it is very much bespoke on a cell by cell basis, therefore conditional formatting not an option sadly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks