Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill Cell
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: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill Color Cell | Excel Worksheet Functions | |||
How to auto fill with fifth cell in a column? | Excel Worksheet Functions | |||
Conditional cell auto fill | Excel Worksheet Functions | |||
Auto fill cell entry | Excel Discussion (Misc queries) | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions |