+ Reply to Thread
Results 1 to 4 of 4

Tricky Conditional Formatting

  1. #1
    Registered User
    Join Date
    06-27-2017
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    2016
    Posts
    2

    Tricky Conditional Formatting

    Hello,

    First time posting in this forum. I have a question over some conditional formatting. I am wanting to format my cells that if they are within 25% of a certain number than they turn into an "x"; if they're not, it's blank. For example, Let's say I'm basing everything off of cell B2, than B3 would be an "x" if it is within the range (B2)(.75)<B2<(B2)(1.25). If it's outside this range, it'd be blank, or a " ". This rule would apply to all cells in column B. I know this will have to be built off of a new rule where I would have to use a formula to determine which cells would be formatted, but I'm not sure which formulas to use, if I would have to have an IF function, or a combination of IR OR's. If anyone has any insight, please let me know. Thank you.

    -avannoord

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Tricky Conditional Formatting

    how would this apply to all cells in B as B3 will be an X or blank
    so what cells are you testing

    not sure i fully understand
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    06-27-2017
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    2016
    Posts
    2

    Re: Tricky Conditional Formatting

    I would be applying it to Cells B3, B4, B5 and so on, all based on the value in B2.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Tricky Conditional Formatting

    you will need VBA to replace a value in a cell , a formula will not do that for you
    not really using "conditional formatting" as defined in excel

    you want to replace the value in B3 based on the values in B2

    not an expert at VBA to do that , so not able to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A tricky Conditional Formatting question...
    By mindfire in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2015, 08:34 AM
  2. [SOLVED] Tricky Conditional VLookup
    By Kapital in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-09-2013, 07:24 AM
  3. Tricky conditional formatting
    By ZoharFurman in forum Excel General
    Replies: 1
    Last Post: 10-27-2013, 12:49 PM
  4. [SOLVED] Tricky one-Conditional Formatting from todays date
    By leanne2011 in forum Excel General
    Replies: 3
    Last Post: 09-15-2012, 01:28 PM
  5. [SOLVED] tricky conditional formatting!
    By wannabe_guru in forum Excel General
    Replies: 14
    Last Post: 05-07-2012, 09:34 AM
  6. tricky Advanced Conditional Formatting
    By rajbloggs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2009, 08:08 AM
  7. Replies: 7
    Last Post: 01-09-2006, 09:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1