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.


--
scottwilsonx
------------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128
View this thread: http://www.excelforum.com/showthread...hreadid=345793