Results 1 to 5 of 5

Highlighting low quantities from Total

Threaded View

euwest30 Highlighting low quantities... 09-17-2008, 07:56 PM
martindwilson conditional format u1 with... 09-17-2008, 08:03 PM
euwest30 It is coming out as True or... 09-17-2008, 08:48 PM
sglife Suppose the value 90 is in... 09-17-2008, 09:32 PM
martindwilson ah 2007 is different look... 09-18-2008, 07:28 PM
  1. #1
    Registered User
    Join Date
    10-18-2006
    Posts
    13

    Highlighting low quantities from Total

    Hi,

    I'm doing up a spreadsheet, more like a Material Take Off, and there are several columns which includes the following:-

    Column T Column U
    Total Received Total Used

    100 90

    The Total Used is ongoing, meaning everytime I use a stock, it's added(Sum) automatically into the Total Used column.

    If lets say I have 100 stock received, and I'm updating and I'm reaching to a point where I have a balance of 10, I'd like Excel to highlight in red that we are running low on this stock in the Total Used colum for each individual product. Is there a way to do it? Even if it means adding another column and excel highlighting in red to say we are >10 of that product.
    Last edited by euwest30; 09-17-2008 at 08:00 PM. Reason: format

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. running total formula for inventory
    By trace1287 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-06-2009, 06:20 PM
  2. row total - column total
    By musini in forum Excel General
    Replies: 8
    Last Post: 03-16-2008, 05:32 PM
  3. [SOLVED] Invoice Total depending on deposit and commission
    By kingfisher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2007, 12:25 AM
  4. Writing a program with changing variables. . .
    By salex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2007, 03:32 PM
  5. Replies: 16
    Last Post: 03-27-2007, 02:14 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