Results 1 to 4 of 4

Cell colored based on another cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-04-2015
    Location
    Nevada
    MS-Off Ver
    MS OFFICE 365
    Posts
    43

    Cell colored based on another cell

    I'm sure this has been asked a hundred times, but I can't seem to figure it out.

    I would like to fill a cell with a color based on another cell if it says "Mon". The cell that has "Mon" in it, has custom formatting to show the day of the week based on the date above it. I don't know if conditional formatting will work with the IF function because it's not truly text. I have attached my spreadsheet. Line 25 and 28 formatted based on line 3 days.

    Example; if b3="Mon", b25 is blue. Actually if it is Mon, Tues, Wed, or Thurs it should make the b3 cell blue. Otherwise it should be gray.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to count only colored cell and extract details of colored cell's row
    By bala04msw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-23-2016, 07:03 AM
  2. Cell colored, but not colored when printed?
    By richard11153 in forum Excel General
    Replies: 1
    Last Post: 02-08-2016, 03:23 PM
  3. Replies: 7
    Last Post: 11-25-2013, 02:19 AM
  4. Auto Fill Cell with Info from a Colored Cell
    By beachbum07 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-31-2013, 03:20 PM
  5. Replies: 3
    Last Post: 10-16-2013, 03:56 AM
  6. [SOLVED] Loop through column check for colored cell and copy that cell to cells below it.
    By RENCE19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2013, 04:51 AM
  7. select one cell another cell is colored in excel 2010
    By roseieroses in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-29-2013, 09:15 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