Formatting Help

  • Thread starter Thread starter kelgiar
  • Start date Start date
K

kelgiar

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)?
 
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.
 
Back
Top