I need to do a conditional format highlighting in Microsoft Excel. G2 to G11 is dollar amounts. I need to highlight them if they are 5% greater than the dollar amount in J1. I tried "=G2>J1+(J1*0.05)" However, it is highlighting cells that are not 5% greater. Please help.
Solved by T. L. in 23 mins