• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

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
0
Frank Freese
Asked:
Frank Freese
  • 3
  • 2
2 Solutions
 
jppintoCommented:
0
 
jppintoCommented:
Please take a look at the attached sample...
ConditionalFormatting.xlsx
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
TracyVBA 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now