Results 1 to 4 of 4

Formula to change colour of a cell based on info in two diffrent cells.

Threaded View

Charli07 Formula to change colour of a... 04-20-2019, 06:33 AM
Aardigspook Re: Formula to change colour... 04-20-2019, 07:49 AM
Charli07 Re: Formula to change colour... 04-24-2019, 01:54 PM
Melvosh Re: Formula to change colour... 04-24-2019, 04:06 PM
  1. 04-20-2019, 06:33 AM #1
    Charli07 is offline
    Registered User
    Join Date
    04-17-2019
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    4

    Formula to change colour of a cell based on info in two diffrent cells.

    Hi Guys, Are you able to help me with the formula for the following.
    jones start date 13th of April 2019.
    Smith terminate date 29th may 2019.

    I need a formula to change colour based on information in two cells In excel

    All cells prior to 13th April for Jones and all cells after 29th may 2019 for Jones.

    i don't think i am explaining this fully. i Cant attached a copy of the excel spread sheet to is post.
    Last edited by Charli07; 04-20-2019 at 06:36 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change Colour for Blank Cells based on date in another cell
    By LMills77 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2018, 06:33 PM
  2. How to change cell colour, if the colour is based on value from formula?
    By darah237 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2016, 11:40 AM
  3. Change colour of cells based on another cell's colour (Not value)
    By LTrain89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 08:44 PM
  4. Change cell colour, based on matched cells in sheet 2
    By Bobbo Jones in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 02:27 AM
  5. Change Colour of 3 Cells based on Value of Other Cell
    By hazza147 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2010, 05:57 AM
  6. Change colour of cells based a cell?
    By smogsy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2010, 09:22 AM
  7. change a cell colour via a diffrent cell
    By garethtaylor in forum Excel General
    Replies: 7
    Last Post: 11-23-2009, 04:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1