+ Reply to Thread
Results 1 to 2 of 2

Change colour of a cell depending on value in a list

  1. #1
    Registered User
    Join Date
    02-10-2020
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    12

    Cool Change colour of a cell depending on value in a list

    Hello i think this will be really easy for many of you to solve.
    What i want is for cell F23 and F24 to turn white or blank if the list in C20 is Ensidig. If the value is Tvåsidig i want it to be grey. (complicated swedish words)

    I tried to solve it by using conditional formatting, but i couldnet figure it out :/

    Thanks in advance

    Sincerely

    Gustav
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Change colour of a cell depending on value in a list

    Clear cells F23/24 (as expected for Ensidig).
    Then select both of them and in CF, choose last option in rule setting and put this formula:

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


    then set grey filling for cells, clikc OK, click OK.
    And should works.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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] Colour change depending on drop down list
    By Davidbraico in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-10-2018, 02:23 AM
  2. Replies: 2
    Last Post: 08-11-2018, 05:22 AM
  3. How do I change the cell colour depending on if statement result?
    By bahamasanita in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2013, 05:10 PM
  4. [SOLVED] How to change the colour of a 3rd cell depending on result of 2 others
    By BBoyAl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2012, 03:13 AM
  5. How to change a cell colour depending an a different cells value?
    By abb16ott in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-23-2009, 04:05 AM
  6. Change Cell Colour Depending on Date
    By Owlsfan in forum Excel General
    Replies: 2
    Last Post: 07-27-2008, 06:15 AM
  7. Change colour of cell depending on content
    By blain in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-17-2006, 08:47 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