Absolute value (ABS) in conditional format

Absolute value (ABS) in conditional format

Posted by: victoria.shkeda on 5 April 2018, 9:38 am EST

• 

  victoria.shkeda

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 April 2018, 9:38 am EST

  Can I use an absolute value of cell(s) in conditional formatting? Can I use it with range of cells comparing to other range of cell?

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2018, 1:10 am EST

  Hi,

  For comparing range of cells using their absolute values and conditionally formatting them, though there is no direct way, it can still be achieved. One simple way is to manually compare the absolute values of cells(using Maths.Abs() method ) while traversing the cell ranges and apply formatting as desired.

  Please refer attached sample application for implementation.

  Regards,
  
  Ruchir AgarwalConditionalFormatting.zip

• 

  victoria.shkeda

  • Post Options:
  • Link
    Copy

  Posted 11 April 2018, 7:28 am EST

  Thank you for reply. I will try it.