Solved

conditional formatting in excel vba

Posted on 2014-02-20
1
202 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
Comment Utility
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now