How to set - greater than / less than values

[BrewCrew55]

I am having trouble setting greater than / less than values on my spreadsheets.
I do not want a whole color chart, just the individual cells that might be out of a measurement range.

Thank you in advance for any assistance.

[LeroyG]

Conditional Formatting?

Conditional Formatting.ods (8.6 KB)

[LeroyG]

@BrewCrew55

I do not want a whole color chart

Maybe a different fill color for some bars:

B1: =HEX2DEC(IFS(A1<2;"50AA50";A1>3;"AA5050";A1<>"";"505050"))
color bars.ods (16.2 KB)