Thread: how do I do conditional formatting for absolute values?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carol Carol is offline
external usenet poster
  
Posts: 115
Default how do I do conditional formatting for absolute values?
I am trying to set up conditional formatting so that an absolute value
greater than 3 will change the cell background color to red. I have tried:
=(abs(f5))3 with f5 being the cell location.
Reply With QuoteReply With Quote