Conditional Formating

[Donna]

Can you please help with a formula for conditional formating? What I have is
a spreadsheet and in one column there is either a yes, no, or blank. If the
field is yes then in the next field there should then be a date. I would like
to highlight the date field if it is blank.

 

[Jacob Skaria]

With Yes in A1 select B1 and use the below formula for Conditional formatting

=AND(A1="Yes",B1="")

and select a color (Fill) and apply that for Col B...

If this post helps click Yes

 

[Donna]

Jacob I don't know what I am doing wrong but it is highlighting fields both
with dates and without dates.

 

[Jacob Skaria]

Which version of Excel do you use? 2003 or 2007

 

[Jacob Skaria]

Donna, please go through the below; I am sure this will help you..

http://www.contextures.com/xlCondFormat02.html

If this post helps click Yes