Conditional formatting would do the trick...

Select one of the cell you want the format to appear then enter this on
conditional formatting selecting "The formula is":

=len(Current Cell Address)0 - create the format you want. This will
recognize either text or value.

Hope this helps.

Ed O'Brien wrote:
I posted this earlier but for some reason cannot see it.

Excel 97/2003 & 2007

I have a sheet which is completed daily by a user.

The rows number about 30 cells (entries) and columns relate to the days of
the month. The day is enumerated in the first column 1 thro 31 (say).
So, to picture it, you have a blank chart with the date listed down the left
and columns named across the top.

Does anyone know of a formula to colour fill the date cell (highlight) if a
number is entered in any of the cells in that row?

TIA for any help.

Ed

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1