Recording a Macro for Conditional Formatting
Hello,
I tried to record a macro to create conditional formatting rules, but to no avail.
- First request, how to record a macro from conditional formatting rules?
- Second request, please write me the VBA code of the following conditional formatting rules.
Conditional Formatting:
Formula =O5<=N5 (Font RED) Applies to =$N5:$Q$168
Formula =O5>=N5 (Font GREEN) Applies to =$N5:$Q$168
Help much appreciated,
Thanks,
Kerri-Anne
Start macro recording
Select cells N5:Q168
Select Conditional Formatting from the menu and apply these RulesFormula =$O5<=$N5 (Font RED)Stop recording
Formula =$O5>=$N5 (Font GREEN)
Decide which rule gets the equal sign otherwise it defaults to the the first rule.
Last edited by AlphaFrog; 10-16-2019 at 06:45 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Originally Posted by AlphaFrog
Sorry, perhaps I should have been clearer, this is exactly what I did however it didn’t work...
Show your recorded macro
Did you use the red $. They are necessary.
What exactly does "didn't work" mean; wrong cells highlighted, no cells highlighted, code errors?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks