Can't record macro for Conditional Formatting

[wilkisa]

I am trying to record a macro for conditional formatting but when I check the VB Editor after I finish recording it, it only has

Sub CFTest()
'
' CFTest Macro
'

'
Range("D1:D4").Select
End Sub


Can someone help me get the keystrokes to record or tell me what I need to do?

Thanks,
Shirlene

 

[Yard]

Thanks for the reply, Jonmo. I recorded my macro again. For each step in the condition, I hit APPLY before I hit New Rule for the next condition. I verified that I completed it and hit OK when done. I then opened the VBEditor and checked the module; it is just exactly as I pasted it in the first part of this thread.

Do I need to enable or add something? I'm just stumped!

Hi, I just experienced exactly the same problem and was just as stumped.

However, if you choose "New rule" from the Ribbon Conditional Formatting menu, then it records it. Changes made through the Manage Rules dialog appear NOT to be recorded.

Hope that helps.

 

[Kimbly808]

However, if you choose "New rule" from the Ribbon Conditional Formatting menu, then it records it. Changes made through the Manage Rules dialog appear NOT to be recorded.

Hope that helps.[/QUOTE]

THANK YOU!!

This little note kept me from banging my head against my desk. I couldn't figure out why some (seemed very random) of my condiontional formatting macros weren't recording!

I can confirm your note that Excel won't record conditional formatting if you select "manage rules" vs. "new rule".

Thank you again!

 

[NewOrderFac33]

Several months later, but a big thank you from me too, for soling this problem this morning!

 

[pdevito3]

My guess is that you're not "Completing" the setup of the conditional format.

The macro recorder doesn't record your conditions untill you click OK all the way through,and are back at the sheet and the conditional formatting is actually functioning.

If you're just going in and putting in the criteria and selecting the format, then clicking Cancel, that's why it's not being recorded.

I had the same problem as the poster. I was hitting "Apply" and then "OK." Once I skipped hitting ""Apply" and hit "OK" immediately, it recorded. Goo call. Much appreciated.

 

[pdevito3]

However, if you choose "New rule" from the Ribbon Conditional Formatting menu, then it records it. Changes made through the Manage Rules dialog appear NOT to be recorded.

Hope that helps.

THANK YOU!!

This little note kept me from banging my head against my desk. I couldn't figure out why some (seemed very random) of my condiontional formatting macros weren't recording!

I can confirm your note that Excel won't record conditional formatting if you select "manage rules" vs. "new rule".

Thank you again![/QUOTE]


Mine worked just fine with manage rules, I just had to hit "OK" immediately and not hit "Apply." Idk if it matters, but I'm using Excel 2010

 

[sgonz95]

THANK YOU!!

This little note kept me from banging my head against my desk. I couldn't figure out why some (seemed very random) of my condiontional formatting macros weren't recording!

I can confirm your note that Excel won't record conditional formatting if you select "manage rules" vs. "new rule".

Thank you again!

Mine worked just fine with manage rules, I just had to hit "OK" immediately and not hit "Apply." Idk if it matters, but I'm using Excel 2010[/QUOTE]

Thank you, thank you, thank you! This has drove me crazy for months! I would have never guessed the stupid "Apply" button was causing the macro not to record conditional format. Again, thank you!

 

[Skettie]

Seriously... thank you!

 

[ntahall]

Mine worked just fine with manage rules, I just had to hit "OK" immediately and not hit "Apply." Idk if it matters, but I'm using Excel 2010

This is it and still persists in Excel 2016. Thank you.

 

[kelzipan]

Over 2 years later same in Excel 2016. I couldn't record in my personal macro workbook but could in "this workbook". Seems like just "OK" works as others said. Not "Apply" and then "OK". Not adding anything except that it's still an issue in 2020. Thanks for the solution.