| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Row after entering data into one cell
Hi,
Let assume you want to color the range A:F whenever the rows A cell has data Suppose you are starting with A1. Select the entire range, A1:F1000 for example and choose Format, Conditional Formatting, pick Formula is from the first drop down and enter the formula =$A1 Click Format and pick a color on the Patterns tab -- Thanks, Shane Devenshire "Spankie1" wrote: I have a worksheet that I would like to fill the row red after I enter data in one of the rows cells. Help I can't figure this out! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exit cell automatically after entering data | Excel Worksheet Functions | |||
| Time with entering data in the corresponding cell | Excel Discussion (Misc queries) | |||
| Coloring of cell when entering data | New Users to Excel | |||
| Entering data in a cell | Excel Discussion (Misc queries) | |||
| entering data in certain cell | Links and Linking in Excel | |||
Hybrid Mode
