Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

conditional formatting in excel vba

Posted on 2014-02-20
1
Medium Priority
?
215 Views
Last Modified: 2014-03-20
i would like to have a cell text value be highlighted if the values in the cells are

0,2 to 14,19 to 25 using conditional formatting.thanks
0
Comment
Question by:Svgmassive
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 26

Accepted Solution

by:
pony10us earned 2000 total points
ID: 39874721
One method is to use conditional formating based on the following formula:

=OR($A$1=0,$A$1=2,$A$1=3,$A$1=4,$A$1=5,$A$1=6,A$1$=7,A$1$=8,A$1$=9,A$1$=10,A$1$=11,A$1$=12,A$1$=13,A$1$=14,A$1$=19,A$1$=20,A$1$=21,A$1$=22,A$1$=23,A$1$=24,A$1$=25))

Or to make it easier to read:

=OR($A1=0,(AND($A1>1,$A1<15)),(AND($A1>18,$A1<26)))

Place your cursor in the cell you want to format and select the Conditional Format button. Select New Rule and then Use a Formula. Adjust the cell reference (A$1) to the cell the value is in.
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question