Solved

MS Excel 2010 Logical Function to set font color

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

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 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…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

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