Conditional Formating

D

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

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
 
D

Donna

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

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

Mail Merge Directory Conditional Page Break 0
Conditional Formatting question.... 1
Cobditional Formatting Rows based on dates in action plan. 0
Conditional formatting with dates 7
Publisher is filling blank lines with data 2
Dealing with a Pivot Table (when I don't want to) 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Need Help with a VBA subroutine 0

Top