Thread: Conditional Formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Conditional Formatting
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?
Reply With QuoteReply With Quote