Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill a row of cells
I have Windows XP using Excel 2003 - using a spreadsheet with several several
rows of data - I have them highlighted in yellow if still open- once it is closed - i put in a date and then manually highlight the row and select no fill - so then it is white again. Is there a way to have the whole row change to no fill if I put a date in that row for example I use columns a through m for the information needed - I put a date in column L when it is complete. I would like columns a - m for that row go from yellow to white when a date is entered. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. | Excel Discussion (Misc queries) | |||
i want cells to auto fill with colour when i enter a number | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions |