Conditional formatting with two columns

J

Jade Summers

I am looking for some help with some conditional formatting.

Column G = Date competed
Column H = Expiry date
Column I = Date completed
Column J = Expiry date

What I want the formatting to do is:
Green - When H and J are >TODAY()+181) make entire column is green
Red - When H and J are <TODAY()) make entire column is red
Yellow - When H or J is less than 180 days from today make entire colum
yellow and bold the G&H or I&J less than the 180 days

I am hoping this is possible. My brain just isn't working today and
cannot figure it out.

Thank you in advance for all your help
 

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

Conditional Formatting in Excel 2003 2
Conditional formatting with dates 7
Date Conditional Formatting 4
Conditional formatting dates 3
Conditional Formatting with VBA 4
Comparing two columns with conditional formatting 4
conditional formatting date and blank cell 4
Cobditional Formatting Rows based on dates in action plan. 0

Top