Results 1 to 12 of 12

How to flag a cell a colour based on measurements entered elsewhere?

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2015
    Location
    Scotland
    MS-Off Ver
    Excel Mac 2011
    Posts
    9

    How to flag a cell a colour based on measurements entered elsewhere?

    I have a spreadsheet which calculates cost of lots of different types of materials based on the size entered.

    there is a length cell (B5)
    and a width cell (B6)

    these are there for the user to enter the size into in mm.

    the table below that has lots of types of materials with rows of prices which change based on the size entered and each column represents what the material will be applied to.
    (I have attached a screenshot of it)

    for an example i will use row 13 which represents Vinyl 610mm
    there is column for media only, and the vinyl applied to various types of board 3mm/5mm/10mm etc, the formula in each cell calculates the cost based not he measurements and base costs worked out on a separate tab of the spreadsheet.

    how can i additionally tell specific cells to highlight a colour if the size entered is larger than the media to warn the user?
    For example cell B13 is the Vinyl, and shows the cost for the vinyl only at the size entered, but the maximum width for this is 610mm so i want it to highlight red to warn the user that the size entered is not possible.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Colour a cell background if 'result' is entered by macro
    By Tanyab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2013, 05:56 AM
  2. [SOLVED] Creating a colour code that displays in a specific % cell based upon figures entered
    By 'MMSA_MAX in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2012, 08:10 AM
  3. Help changing colour of cell depending on date entered
    By dazlia in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-07-2011, 10:59 AM
  4. [SOLVED] Change Row Background Colour When Text Is Entered Into A Cell
    By AlexRoberts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2010, 01:28 PM
  5. How do i change the colour of a cell when text is entered
    By Deanobey in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-30-2009, 02:59 PM
  6. Auto change colour of cell when text / letter entered into cell
    By Nik_AU in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2007, 07:36 AM
  7. Replies: 1
    Last Post: 02-15-2006, 12:52 PM
  8. Replies: 0
    Last Post: 02-15-2006, 12:25 PM

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