• 541K Members
• 6,761 Online
• 645K Conversations
SOLVED

## Conditonal Formatting in Excel

Highlighted
Occasional Contributor

# Conditonal Formatting in Excel

I would like to use two colors for coloring dates that are meetings.  These dates are space out for the last three months. I want to color green for the first year and say red for the year beyond.  I have tried several ways and not getting the same results.

My summary sheet has all formulas and the conditional formatting that I tried did not work the same way.

I have tried several tutorials and not getting the right answers.

P.S. I am using dates.

6 Replies
Highlighted

# Re: Conditonal Formatting in Excel

Select your date range ( assuming as starting in A2) and apply this conditional formatting formulas:
For green:
=A2<=EndOfFirstYear
For red:
=A2>EndOfFirstYear
Highlighted

# Re: Conditonal Formatting in Excel

It did not work

Here is example"

 A B C D E F H 10/18/2018 6/7/2017 6/7/2017 4/9/2019 11/27/2018 11/27/2018 11/29/2018 3/9/2018 10/23/2017 10/23/2017 10/24/2017 10/24/2017 8/30/2018 8/30/2018 4/9/2019 2/1/2019 2/1/2019 2/1/2019

# Re: Conditonal Formatting in Excel

This did not work or I didn't understand the process.   Here is another @Twifoo

 A B C D E F 10/18/2018 6/7/2017 6/7/2017 4/9/2019 11/27/2018 11/27/2018 11/29/2018 3/9/2018 10/23/2017 10/23/2017 10/24/2017 10/24/2017 8/30/2018 8/30/2018 4/9/2019 2/1/2019 2/1/2019 2/1/2019
Highlighted

# Re: Conditonal Formatting in Excel

Please attach your sample file so that it would be easier to test the appropriate conditional formatting formula.

Highlighted

# Re: Conditonal Formatting in Excel

Attach is sample of what I am working with. I want to highlight less than year and red over a year old.

Highlighted
Solution

# Re: Conditonal Formatting in Excel

Perhaps

``=(A3>EDATE(TODAY(),-12))*ISNUMBER(A3)``

for the green and

``=(A3<=EDATE(TODAY(),-12))*(A3>1)``

for the red, applied  to =\$A\$3:\$I\$8

Related Conversations
Unable to delete empty rows and columns
G_Torres in Excel on
1 Replies
nursekimberley in Excel on
2 Replies
Excel or Access? basic advice from which to start from.
grifton in Excel on
2 Replies
Goal seek
Abui_2195 in Excel on
3 Replies
Preparing a stacked chart
EuroSree in Excel on
2 Replies