Link to home
Start Free TrialLog in
Avatar of Scott Jackson
Scott JacksonFlag for United States of America

asked on

MS Excel 2010 Logical Function to set font color

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.
ASKER CERTIFIED SOLUTION
Avatar of Sam Simon Nasser
Sam Simon Nasser
Flag of Palestine, State of image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Scott Jackson

ASKER

I'll try working with that on my PC