+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting for adjacent cells

  1. #1
    Registered User
    Join Date
    05-19-2020
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    2

    Question Conditional formatting for adjacent cells

    Hello,

    I'm using numerical values to identify the status of projects as 1-completed/ 2-awaiting approval/ 3-requires attention (problem)
    I wish to use conditional formatting so that all the cells in a row associated with a project is colored according to the numerical "status" value attributed (green-1, yellow-2, red-3)
    I'm able to use conditional formatting so that the cell containing the numerical value is colored, but I don't know how (if it is possible ) to color the other cells in the row according to that numerical value.

    The attachment uses the same disposition as the actual spreadsheet.
    My goal would be that when I enter let's say "1" in F8, B8 to G8 are colored green.

    Sorry if this has already been posted, I couldn't find the answer
    Thanks!
    Attached Files Attached Files
    Last edited by Kiliak07; 03-05-2021 at 10:59 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Conditional formatting for adjacent cells

    I would use a formula and use a $ in front of the column you are testing
    3 formulas setup - one for each colour
    select the range B8 to say G30 to allow other entries , change row to suit
    Then use a rule
    $F8=1
    new rule
    $F8=2
    new rule
    $F8=3
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,714

    Re: Conditional formatting for adjacent cells

    You need to set up 3 conditions for the 3 colours and apply them to the range $B$8:$G$11. The easiest way is to select that range first, and then click on Conditional Formatting | New Rule | Use a formula... , and then use this formula in the dialogue box:

    =$F8=1

    Then click on the Format button | Fill tab and choose green, then OK your way out. With the range still selected, repeat and use the formula:

    =$F8=2

    and choose yellow as the fill colour, then repeat once more with the formula:

    =$F8=3

    and set red as the fill colour. You can also delete the existing conditions.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    05-19-2020
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    2

    Re: Conditional formatting for adjacent cells

    Thanks, worked great!

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Conditional formatting for adjacent cells

    you are welcome

+ 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. Conditional formatting of adjacent cells
    By Coffee-Hound in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-10-2017, 07:09 PM
  2. Conditional Formatting Adjacent Cells
    By brb73ajb in forum Excel General
    Replies: 3
    Last Post: 03-07-2014, 12:03 PM
  3. Conditional formatting adjacent cells...
    By Boucka in forum Excel General
    Replies: 3
    Last Post: 08-29-2013, 05:39 PM
  4. Conditional formatting of adjacent cells
    By Johnny Utah in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2013, 06:10 PM
  5. Conditional Formatting - Adjacent Cells
    By dlorenzo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-23-2011, 03:48 PM
  6. Conditional Formatting adjacent set of cells
    By phillyfan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2007, 03:07 AM
  7. [SOLVED] conditional formatting adjacent cells
    By jbsand1001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2005, 06: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