Formatting Help

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)?
 
S

Sean Timmons

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
Format cell based on cell color 3
Conditional Formatting 2
Link format along with contents of another cell 1
Comparison of columns using Conditional Formatting 3
Conditional Formatting in 2007 3
Conditional formatting question 5
Dates linked in Excel files 3

Top