Issue with conditional formating

Experts,
I'm trying to apply a conditional formating at follows
Rule 1:
if the date in F12:F21 => $F$8 apply my formating.
Rule 2
if the date in F12:F21 <= C$8$ apply my formating
Frank FreeseAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
Please take a look at the attached sample...
ConditionalFormatting.xlsx
0
 
jppintoCommented:
0
 
TracyVBA DeveloperCommented:
Try something like this, highlight cell F12 and enter the conditional formatting as shown below (Tools --> Conditional Formatting).

Then click OK.  Then on cell F12, click the Format Painter (looks like a little paint brush) and select cells F13:F21.
ConditionalFormatting.jpg
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
TracyConnect With a Mentor VBA DeveloperCommented:
oops, meant to say this
(Format --> Conditional Formatting).

Not this
(Tools --> Conditional Formatting).

And of course, mine is for Excel 2003.
0
 
jppintoCommented:
For Excel 2010, select the range F2:F21 and on the Home tab, click on the Conditional Formatting button and select Manage Rules. Click on the New Rule button and select the second option from the "Select a Rule Type". On the bottom of the dialog window put the Cell Value - "greater than or equal to" and select the cell F8. Click on the Format button to choose the formatting that you want to apply and click OK. Repeat for the second rule.

jppinto
0
 
Frank FreeseAuthor Commented:
great job folks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.