I'm unable to enter a conditional format as part of a Macro. Row H contains multiple data. The desired result of the conditional formating should be that if a cell contains either C,EB,O,P,or VB the cell color will be red.
I entered Formula is =IF(OR(H="C",H="EB",H="O",H="P",H="VB"),1,0) but it's not working. Please help.