Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how to create a macro named ShowRemodel using macro recorder. The macro should use conditional formatting to highlight column G (G7:G56) with Light Red Fill
how to create a macro named "ShowRemodel" using macro recorder. The macro should use conditional formatting to highlight column G (G7:G56) with Light Red Fill and Dark Red Text if the text contains "Remodel" . Otherwise, no formatting appears. In the Developer tab, click on Visual Basic. Copy all the code (everything on the page), and paste it inA1 of the Sheet named Code.
how to create a macro named "ShowRemodel" using macro recorder. The macro should use conditional formatting to highlight column G (G7:G56) with Light Red Fill and Dark Red Text if the text contains "Remodel" . Otherwise, no formatting appears. In the Developer tab, click on Visual Basic. Copy all the code (everything on the page), and paste it inA1 of the Sheet named Code. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started