Solved

conditional formatting in excel vba

Posted on 2014-02-20
1
211 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
1 Comment
 
LVL 26

Accepted Solution

by:
pony10us earned 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

856 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