Forum Discussion
Macros or Find
HansVogelaar Thank you so much for responding however I am have difficulty in following your directions which may be because I am using a Mac. When I get to the Conditional Formatting screen it does not show me a place to enter your formula. I can see where it says formula under the minimum and maximum value. That did not work for me. This is a new subscription for me and I am transitioning from an old version. It is almost like starting over.
Thanks. John
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
