conditional formating rules vba code

aboly8000

Board Regular
Joined
Sep 4, 2019
Messages
59
Hello
I tried to record a macro from conditional formating rules, but to no avail.
First request, how to record a macro from conditional formating rules?
Second request, please write me the vba code of the following conditional formating rules.




 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

aboly8000

Board Regular
Joined
Sep 4, 2019
Messages
59
I found the solution. To record a macro, you must select a new rule.
developer -- record macro -- Home -- conditional formatting -- New rule ...
 

Watch MrExcel Video

Forum statistics

Threads
1,095,235
Messages
5,443,278
Members
405,223
Latest member
Industrial_Eng_SA

This Week's Hot Topics

Top