| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Help
How do I format a cell to fill in with a color if the cell next to it is
filled in with a date and the original cell is not filled in with a date (Excel 2007)? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting Help
Are you looking for any situation where a value is entered in the adjacent
cell, or are you wanting to differentiate between date and any other value type? If the former,go to Conditional Formatting and set the formula to =AND(A1="",B1<"") Substituting current ell for A1 and adjacent cell for B1. "kelgiar" wrote: How do I format a cell to fill in with a color if the cell next to it is filled in with a date and the original cell is not filled in with a date (Excel 2007)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Hybrid Mode
