+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting use a formula to determine which cells to format

  1. #1
    Registered User
    Join Date
    03-30-2009
    Location
    Chicago, IL, USA
    MS-Off Ver
    Excel 2003
    Posts
    37

    Question Conditional formatting use a formula to determine which cells to format

    I was using conditional format in Access and I thought it would work the same way in excel but it is a little different. I was trying to use Conditional formatting where I would use a formula to determine which cells to format and I entered the rule but it does not seem to be doing anything. I have a column with an actual color name and I want to change that other cell to that color. So if the one cell has the word "Green" in it. I want to make that other cell's background green. Here's what I put it but it has no effect:

    Well it is not letting me upload now so my formula I = M6 = "Green" then in the format window I put in background color Green but on the actually spreadsheet nothing happens even when it says "Green" in cell M6. What am I doing wrong.

  2. #2
    Forum Contributor
    Join Date
    03-14-2013
    Location
    England
    MS-Off Ver
    2007
    Posts
    185

    Re: Conditional formatting use a formula to determine which cells to format

    Conditional Formatting/Highlight Cells Rules/Equal To....

    ="Green"

    Example attached

    Hope it helps
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    England
    MS-Off Ver
    2007
    Posts
    185

    Re: Conditional formatting use a formula to determine which cells to format

    Or possibly you mean like this....

    Formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Seems like you might have to set every row individually to do this, which is a right pain. I would also be interested to know if there is a quicker way.
    Attached Files Attached Files

+ 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. Replies: 7
    Last Post: 03-24-2015, 07:44 AM
  2. [SOLVED] Conditional Formatting to Use a formula to determine which cells to format
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-16-2013, 10:29 AM
  3. Replies: 7
    Last Post: 02-20-2013, 06:34 PM
  4. Replies: 3
    Last Post: 08-04-2012, 07:22 PM
  5. [SOLVED] Determine cells that drive conditional formatting?
    By Nicolle K. in forum Excel General
    Replies: 2
    Last Post: 01-06-2005, 10:06 PM

Tags for this Thread

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