Solved

MS Excel 2010 Logical Function to set font color

Posted on 2014-04-28
2
766 Views
Last Modified: 2014-04-28
I have a spreadsheet with three columns for blood pressure and rate: Systolic, Distolic and heart rate.  I want to set a logical function for each column that will set the font color for each cell value based on criteria:

If 70 or under font is purple
If 90 or above and below 120 is green
If 120 or above and below 140 is yellow
If 140 or above it is red

Appreciate assistance with finding a logical function to support this.
0
Comment
Question by:Scott Jackson
[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
2 Comments
 
LVL 10

Accepted Solution

by:
Sam Simon Nasser earned 500 total points
ID: 40027560
check here
http://www.techonthenet.com/excel/questions/cond_format1_2011.php

the trick is by using CONDITIONAL FORMATING
0
 

Author Comment

by:Scott Jackson
ID: 40027577
I'll try working with that on my PC
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site (Experts-Exchange.com in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

617 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