Can I change font color based on an IF condition

Copper Contributor

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?

 

Thanks

3 Replies

@Old_Bill_32 

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.

Thank you,

Bill