Results 1 to 3 of 3

Thread: Using "IF" in conditional formatting

  1. #1
    Junior Member
    Join Date
    Jan 2020
    Posts
    1
    Rep Power
    0

    Using "IF" in conditional formatting

    I'm unsure whether this is possible but I'm wanting to conditionally format the attached data set so that the values in Row 7 will be highlighted "if (row7value-row6value)/row7value≥±0.05". Any help or guidance would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    11
    see attached:
    Select cells C5:BO8, go into conditional formatting, Use a formula to… and use:
    =(ABS(C5-C4)/C5)>=0.05
    Attached Files Attached Files

  3. #3
    Junior Member
    Join Date
    Aug 2014
    Posts
    10
    Rep Power
    0
    Quote Originally Posted by p45cal View Post
    see attached:
    Select cells C5:BO8, go into conditional formatting, Use a formula to… and use:
    =(ABS(C5-C4)/C5)>=0.05
    That doesn't accommodate for the 2 different rows that are supposed to be in the formula or that it is specifically row 7

    Select C7:BO7 and use the following conditional formatting formula:
    =(ABS(C7-C6)/C7)>=0.05

Similar Threads

  1. Replies: 3
    Last Post: 11-17-2019, 11:08 PM
  2. VBA Versions of my "Get Field" and "Get Reverse Field" formulas
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 06-02-2017, 06:15 PM
  3. Replies: 1
    Last Post: 02-10-2015, 09:41 AM
  4. Replies: 4
    Last Post: 09-09-2013, 05:13 PM
  5. Ordinal Suffix (i.e., "st", "nd", "rd" and "th")
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 0
    Last Post: 03-20-2012, 03:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •