Conditional Formating
 

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.
--
Donna

Conditional Formating
 

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
---------------
Jacob Skaria


"Donna" wrote:

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.
--
Donna

Conditional Formating
 

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


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Donna" wrote:

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.
--
Donna

Conditional Formating
 

Which version of Excel do you use? 2003 or 2007
--
If this post helps click Yes
---------------
Jacob Skaria


"Donna" wrote:

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


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Donna" wrote:

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.
--
Donna

Conditional Formating
 

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
---------------
Jacob Skaria


"Donna" wrote:

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


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Donna" wrote:

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.
--
Donna