Scott Jackson
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER