Conditional Formatting
Sorry I misread the post..
Stefi/Mike
Just the below will do as conditional formatting returns true only if the
below formula returns more than 0.
=COUNTIF(A1:A10,"110")
If this post helps click Yes
---------------
Jacob Skaria
"Stefi" wrote:
You are welcome! Thanks for the feedback!
Stefi
€˛Mike McLellan€¯ ezt Ć*rta:
Thanks, Stefi - just what I needed!
"Stefi" wrote:
Use this formula:
=COUNTIF(A1:A10,""&110)0
Adjust range!
Regards,
Stefi
€˛Mike McLellan€¯ ezt Ć*rta:
How do I set the background colour of a cell to Red if the value of any cell
in a range is greater than, say, 110?
|