I have a spreadsheet that I want the top cell of that column font to turn red if in that same column a specific cell meets the criteria of = to or greater than 5. So here, if D2 was 6, then D1 font would turn red.

A B C D E F G
1 ROOM NUMBER: score: 310a 310b 311a 311b 312a
2 TOTAL RN ACUITY: 0 0 0 0 0


Thank you!!