Auto Fill Cell

E

Ed O'Brien

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
 
S

Stefi

Select A1:A31 then Conditional formatting with formula =COUNT(B1:D1)>0 where
B :D are columns you expect to be numbers in, 3 is number of these columns.

Regards,
Stefi

„Ed O'Brien†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Cells 5
Conditional formatting in Excel 2010 2
Conditional Formating and auto filling 1
Auto fill adjacent cells 3
Auto Fill - cell numbering patterns 3
Change Default Auto-Fill-In month 4
Colour cell to return date 4
auto fill options (copy cell, not create series) 4

Top