Results 1 to 6 of 6

=If (forumla) = colour fill cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    =If (forumla) = colour fill cell

    Hey...... first post here.

    Let me start by saying how much I have learnt already whilst simply looking for a solution to my own problem!!!!

    Okay.... here's where I'm at.

    I have two dates lets call them cells A1 and A2. I then have another cell that caluclates the difference in these dates into a simple number (ie not another date) - A3.

    I need one of two things.

    Ideally I want the whole cell (A3) to appear as a Green (fill) cell if the value is below 5, appear Orange if beween 6 and 9 and appear as red if its 10 or over.

    I do not know if you can colour a cell that has a formula in already. So what follows is my current 'work around', which, if you can not colour the A3 cell, then I would need this cell coloured (A4).

    =IF(D12>7,"Urgent Attention",IF(D12<5,"New",""))

    Please ignore the values in the above formula as I was just testing things out.

    thanks in advance.

    Lee
    Last edited by NBVC; 10-05-2009 at 08:58 AM.

Thread Information

Users Browsing this Thread

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

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