Is there any way to format a cell's color to be the same as another cell that has a matching value? I can't see how it could be done with CF (which I'd rather stay away from anyway), so I'm wondering if anyone knows how this could be done - I've manually done this for cells C5:C7 on the Grid worksheet attached, for values that match C18:C25, but it would be nice to do it automatically, otherwise probably not worth the time... Any suggestions greatly appreciated!
Only other way I can think of would be with a few lines of code:
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Formulas cannot pull back formatting, so unless the initial cells where colored using CF (in which case, may be able to use the similar rule), then VBA is the only other option
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks