+ Reply to Thread
Results 1 to 5 of 5

Change text colour based on list option chosen

Hybrid View

  1. #1
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Change text colour based on list option chosen

    Follow these steps:

    Select C9.
    On the Home Tab click Conditional Formatting and choose New Rule.
    Select 'Use a formula to determine..' and for the formula below type in =C$3="Actual"
    Click the Format button and apply whatever you want to do to the cell (colour change etc.) and click OK to confirm your changes.

    Check this is working and if it is:
    With C9 selected click the Format Painter button. Then select all the cells to the right of this and you have set up that row to change colour.

    Repeat this painter step for each row. If you are having trouble with anything let us know.
    Last edited by Harribone; 07-11-2013 at 06:54 PM. Reason: Put $ in correct place
    Say thanks, click *

  2. #2
    Registered User
    Join Date
    05-20-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Change text colour based on list option chosen

    Quote Originally Posted by Harribone View Post
    Follow these steps:

    Select C9.
    On the Home Tab click Conditional Formatting and choose New Rule.
    Select 'Use a formula to determine..' and for the formula below type in =C$3="Actual"
    Click the Format button and apply whatever you want to do to the cell (colour change etc.) and click OK to confirm your changes.

    Check this is working and if it is:
    With C9 selected click the Format Painter button. Then select all the cells to the right of this and you have set up that row to change colour.

    Repeat this painter step for each row. If you are having trouble with anything let us know.
    Thanks so much, Harribone! Your instructions were great and really easy to follow. However, I don't want the whole row to colour when I choose Actual at C9. Essentially each month we will change that month from Forecast to Actual.

    Is the only way to format the colour change to do each individual cell of each month and each row separately? I can do that (of course) but is there a more efficient way so that when I choose 'Actual' for July, it changes the format for ALL the cells in that column labelled expense actual, revenue actual, etc (ie. C9, C15, C21, C27, C33)?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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