I have searched high and low for an answer to this and I'm beginning to think it can't be done.
I am trying to format a cell fill color based on another cell's fill color. Simple right...?
Any help would be appreciated.
I have searched high and low for an answer to this and I'm beginning to think it can't be done.
I am trying to format a cell fill color based on another cell's fill color. Simple right...?
Any help would be appreciated.
Last edited by mfrymyer; 04-05-2010 at 11:16 AM.
And what's criteria for a first color?
Never use Merged Cells in Excel
You could do it with vba and the worksheet's selection change event. Would that be acceptable to you?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks