Results 1 to 4 of 4

Using Text Variable for Conditional Formatting

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel MAC 2011
    Posts
    2

    Using Text Variable for Conditional Formatting

    Hello. I'm trying to reverse engineer a spreadsheet (see attached) and apply the data table to my own spreadsheet. The inspiration spreadsheet (attached) utilizes a 2 variable data table and conditional formatting, where the cells are formatted based on their value in relation to a variable called "Gross". So the rules look something like this:

    Cell Value Between 0 and Gross-1
    Cell Value > Gross
    Cell Value = Gross
    Cell Value < 0
    Graded Color Scale Minimum ="<385000" Maximum =">385000"

    I assume the Gross is calculated as 25% * 350,000 = 87,500. The hard coded value of 385000 is actually incorrect, because it's based on a percentage of 10%... but I'll let that slide The resulting formatting of the data table would support the hypothesis that "Gross" = 87,500. However, when I reset the Conditional Formatting to reference another cell with the calculation result of 87,500 it completely throws off the formatting. I'm simply stumped as to how they are using the text "Gross" as a variable. How/where are such variables set so they can be used in conditional formatting?

    I'm also stumped as to how to apply the data table logic itself to another spreadsheet, but I'll save that question for another post.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problem using a variable that contains text in VBA conditional formatting...
    By TheSaint0001 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-09-2014, 06:26 AM
  2. [SOLVED] Using variable in conditional formatting
    By vtxvtx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2012, 11:43 AM
  3. Add Conditional Formatting To Variable Range
    By nsquared in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2011, 03:06 AM
  4. Conditional Formatting for Variable Cells
    By applefritter in forum Excel General
    Replies: 3
    Last Post: 03-24-2011, 03:26 PM
  5. Replies: 9
    Last Post: 03-16-2011, 01:32 PM

Tags for this Thread

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