Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Excel 2010 Logical Function to set font color

Posted on 2014-04-28
2
Medium Priority
?
804 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
2 Comments
 
LVL 10

Accepted Solution

by:
Sam Simon Nasser earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
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 a watermark for their document, customizing it, and saving it for viewing/printing needs.
Integration Management Part 2

916 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