Forum Discussion
Excel: Format One Cell Based on Values from a Column
Hello all,
I’m trying to conditional format one cell based on the values of a column. If any cell in the Observations column (A2:A52) is greater than CC UCL (F23), then In Control (F25) should appear red. If none of the cells are greater, then it appears green. Buuut the conditional format tool isn’t doing that.
Any ideas of what I'm doing wrong?
Currently I'm trying =A2:A52>F23 in the formatting tool. Any help would be greatly appreciated.
I’m trying to conditional format one cell based on the values of a column. If any cell in the Observations column (A2:A52) is greater than CC UCL (F23), then In Control (F25) should appear red. If none of the cells are greater, then it appears green. Buuut the conditional format tool isn’t doing that.
Any ideas of what I'm doing wrong?
Currently I'm trying =A2:A52>F23 in the formatting tool. Any help would be greatly appreciated.
