Is there a way to conditionally format a cell using a trigger/search word
e.g. look for 'apples in a work book and colour code any cell that has the word 'apples' in it green??
Thanks
Is there a way to conditionally format a cell using a trigger/search word
e.g. look for 'apples in a work book and colour code any cell that has the word 'apples' in it green??
Thanks
Is there some reason why you can't use CF to look at the cell value and apply the format?
What you ask can be done using VBA.
If you have more than three conditions and need a VBA solution then take a look at adapting code from this thread.
VBA Conditional Formatting
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks