John James Wrote:
Try this. Assuming E2 is the first cell with an amount. Highlight the
cells from E2 downwards, select format-conditional formatting, select
"Cell value is" and "Greater than" and paste:

=$F2*1.03

Curiously, the equals sign appears to be necessary.

Good luck

Worked a treat

Thanks a lot


--
forbsey
------------------------------------------------------------------------
forbsey's Profile: http://www.excelforum.com/member.php...o&userid=32760
View this thread: http://www.excelforum.com/showthread...hreadid=525921