Thanks David - this works!! Just goes to show you can always learn more
tricks in Excel!!!!



"David Biddulph" wrote:

You can set conditional format for the whole of row 1 with the formula
=($B1=3), and then if B1 = 3 the whole row will be formatted.
--
David Biddulph

"LDUNN1" wrote in message
...
Currently, Excel Conditional formatting permits the user to format one
cell
based upon the value in that cell.

I would like to see this improved upon - the ability to format multiple
cells depending upon the value of a single cell - eg a whole row or column
could be hi-lited a color depending upon the value in one of the cells in
that row or column.