Forum Discussion
Macros or Find
I am seeking to find a way to search a worksheet and find cells in a column which contain a single word or two amongst the many that may be in the cell and have that trigger a color reformat of an a...
jhicks5charternet Sorry, but my response was merely to point you into finding where to enter a classic CF formula on a Mac. You haven't given us anything to work with when it comes to your requirement. If the other responses that you received don't make sense, please upload a file (without confidential information) and explain what is is you want to format and with what logic.
I am trying to have an executable macro which will search Column A for the word "Jamestown" and if it finds "Jamestown" it will trigger a reformat of the row to have a background color such as yellow or green. /Users/john/Desktop/Macro test sheet..xlsx/Users/john/Desktop/Macro test sheet..xlsx
My actual sheet has several thousand rows
My actual sheet has several thousand rows