View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Mike McLellan Mike McLellan is offline
external usenet poster
 
Posts: 11
Default Conditional Formatting

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?