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
|