Results 1 to 5 of 5

Conditional Formatting - Three Color for Balance v. Actual

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2013 for PC
    Posts
    8

    Conditional Formatting - Three Color for Balance v. Actual

    Howdy! Hoping to get some help with a new project management sheet I am creating for a project we are working on in the architecture office. I am trying to use conditional formatting to notify a design if they are good, close, or over budget hours for each phase.

    Column A has the different phases of design/construction.
    Column B has the Budgeted Hours.
    Column C has the Actual Hours.

    I was trying to figure out how to either do a data bar or just a color gradient to fill the cell so they know they the status on the phase.
    Green = Under Budget/Good | Yellow = At 75% of Budget Hours | Red = at 100% or more of the Budget Hours.

    For example, if I put in anything from 0 to 58 in C4 it would be green since it is less than 75% of 78. It would turn yellow for any values between 59-77 and turn red for any values from 78 on up. And so on with the remained of the C column.

    I was able to do the Green and Red easily, but I couldn't get the Yellow to work for the in between values of 75%-99%. I imagine I might need some if formula or something like that.

    I attached a sample of the sheet I am creating. Thanks in advance for any help!
    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. Conditional Formatting Balance vs. Actual with 3-Icon set
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-08-2013, 11:46 AM
  2. Conditional Formatting with Forcasts and Actual dates
    By arleutwyler in forum Excel General
    Replies: 1
    Last Post: 10-18-2013, 12:51 AM
  3. Replies: 9
    Last Post: 06-14-2013, 04:38 AM
  4. [SOLVED] 3 colour scale conditional formatting with actual vs. predicted figures.
    By Linsie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 08:56 AM
  5. Conditional Formatting Balance Sheet
    By MikeC83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2012, 11:43 AM

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