+ Reply to Thread
Results 1 to 3 of 3

Auto fill a cell with a colour when typing a number

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    613

    Exclamation Auto fill a cell with a colour when typing a number

    Dear experts,

    Herewith attached a work book for which I need your help.

    What I need is;

    When I type numbers in the cells from D4 to D14, E4 to E14 and so on, the particular cell should turn into "Green". All the the cells will remain "yellow" and blank until numbers are entered based on the daily cleaning of machines. When particular machine no is entered in to a cell cell, that cell should turn green(this shows that "service is done for that machine")
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-01-2014
    Location
    canada, montreal
    MS-Off Ver
    word and excel 2007
    Posts
    3

    Re: Auto fill a cell with a colour when typing a number

    Select all cells, go to Conditional Formatting, New Rule..., select Use a formula to determine which cells to format, insert this formula =ISNUMBER(D4) press Format..., select Green, Ok, Ok, done.

    Or Select all cells, go to Conditional Formatting, Highlight Cells Rules, Greater than..., enter 0, with Custom Format..., go to the Fill tab, pick Green press Ok, Ok, done.

  3. #3
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    613

    Re: Auto fill a cell with a colour when typing a number

    Thanks a lot...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I auto fill a cell in one worksheet by typing a code number
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 PM
  2. [SOLVED] Can I auto fill a cell in one worksheet by typing a code number
    By Gomer Pyle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  3. Can I auto fill a cell in one worksheet by typing a code number
    By Gomer Pyle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. [SOLVED] Can I auto fill a cell in one worksheet by typing a code number
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM
  5. [SOLVED] Can I auto fill a cell in one worksheet by typing a code number
    By Gomer Pyle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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