Forum Discussion
Table conditional formatting
Hi all, I am trying to compare a column which is an index match returned value to a static value cell. And highlight any variances in the index match column if different. =[@[Updated Departm...
You cannot use structured table references in a conditional formatting formula (at least not directly).
Use the cell references instead, referring to the first data row of the table.
- Hi Hans,
Thanks for the reply, i have attempted using cell references, and it does not appear to work. I've tried =$G$2<>$L$2.
i assume the error i am making is straight forward, but whichever way i have attempted to reference the cells, i either get no formatting, or it formats the entire range even where the value isn't true (as if it's referencing only one value).Hi Hans,
I am still facing some difficulties, i have included a test document which fairly represents what im trying to do, as you can see the conditional format should reference row to row, and only highlight where the value varies, in the example it is highlighting an example where there is no change.
- Thank you,
Bill 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.
