Results 1 to 3 of 3

Thread: Using "IF" in conditional formatting

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-09-2020, 04:03 PM #1
    Goose93
    Goose93 is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Excel and XP Operating System Tests (proc entry pt "GetDataFormEX" not found in the DLL "KERNEL32)
    By DocAElstein in forum Test Area
    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. Inconsistent "greater than" and "less than" calculations
    By wpryan in forum Excel Help
    Replies: 1
    Last Post: 02-10-2015, 09:41 AM
  4. how to equalize the value of an "alphabet" to "zero"
    By kernelx in forum Excel Help
    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

Bookmarks

Posting Permissions

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

Forum Rules