Thread: how do I do conditional formatting for absolute values?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how do I do conditional formatting for absolute values?
Carol

Formula is
=ABS($F$5)3

works for me and this can go in F5 or any other cell

Mike


"Carol" wrote:

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