Hello,

I have a drop down menu in excel.

And I want to be able to change the format of some cells when they
select a certain category in the drop down menu "custom".

When they come back to the others categories I want the formating to
come back as normal.

I thought to put and IF inside the macro, but I am not sure if this can
work, any ideas?
Thank you so much, I really appreciate it.

Mary.