Solved

MS Excel 2010 Logical Function to set font color

Posted on 2014-04-28
2
752 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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

738 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