Hi,
I am trying to based on what is in column M, format column H,J, and K.
So, if M="FDA" then H,J, and K should be formatted with a particular shading and pattern style.
The rule should apply to every row. I don't know if I should write a macro to apply to every row? Or I can use the conditional formatiing feature?
Please advise,
Thanks,