Thread: how do I do conditional formatting for absolute values?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I do conditional formatting for absolute values?
=ABS(F5)3 works for me.


Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 15:34:02 -0800, 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