Forum Discussion
Can I change font color based on an IF condition
I've got a spread sheet tracking my blood pressure. On days it's high, I'd like the numbers to display in red, as opposed to normal days in black. Can I use IF (value) < then CHANGE FONT COLOR TO X? ...
You can use conditional formatting.
Select the cells with - for example - your systolic blood pressure readings.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than' from the second drop down.
Enter the threshold in the box next to it, for example =140
Click Format...
Activate the Font tab.
Select red as font color.
Click OK, then click OK again.
You can do the same for your diastolic readings, with a different threshold, for example 90.