Hello everyone, I need some help with creating some conditional formatiing on the following sheet:

Column A contains a range of row titles
COlumn B contains my first percentage
Column C contains my second percentage
Column E contains my third percentage
Column F contains my fourth percentage.
The data runs from row 8 to 46.

What I want to do is highlight by shading the box yellow those entries in column C which are higher than column B, and highlight entries in column F that are higher than column E.

To help me do this, I have a formula in column G that returns "higher" if column C is higher than B, and in column H a formulae that returns "higher" where column F is higher than column E - not sure if this step is necessary if done in VBA.


Any assistance gratefully received.

Scott.