Morning everyone,
I am trying to set up a macro which searches for a particular text string and colours the cell in when this text string is found.
At the moment, I have got the macro to search for the cell and currently it colours the cell in Green.
I now want to develop the macro so when I fill in Cell B2 in a colour I want by using the fill function in Excel, the macro when run, determines what colour this is and fills all cells that contain the predefined text string in, with this colour.
At the moment, in the macro, the colour is defined as follows:
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 5296274
.TintAndShade = 0
End With
Many thanks!
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks