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 The screens on a Mac are a bit different.
1) New Rule... on the Home ribbon.
Then choose Classic in the Style field.
Then select "Use a formula .........." from the field below the Style.
Now you can enter your formula.
I did enter my formula and it worked for one cell only. How do I get it to search the entire column and reformat the appropriate cells? Thanks John
Make sure that you select the entire column before creating the rule.
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
