But in your example, all values fall into the less than -1% or greater than 1% range. Select the entire column H, add conditional formatting formula of ...
Edit: Is it 0.1%, or 0.1?=($A1<>"")*(ISNUMBER($H1))*(($H1<-0.01)+($H1>0.01))
But in your example, all values fall into the less than -1% or greater than 1% range. Select the entire column H, add conditional formatting formula of ...
Edit: Is it 0.1%, or 0.1?=($A1<>"")*(ISNUMBER($H1))*(($H1<-0.01)+($H1>0.01))
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Posting Permissions
Reply With Quote