Solved

conditional formatting in excel vba

Posted on 2014-02-20
1
213 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 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
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 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 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 …

691 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