+ Reply to Thread
Results 1 to 2 of 2

Help with conditional formatting:P3 to turn blue,

  1. #1
    Registered User
    Join Date
    08-02-2009
    Location
    TX, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Help with conditional formatting:P3 to turn blue,

    I'm sure this is easy but I do not know how to do it, any help would be great and thanks in advance.

    What I want to do is- When I type the letter X in cell A3, I need cells E3 through P3 to turn blue, cells B3/C3/D3 need to be un-affected.

    If someone would tell me how to do this, it would be great, Thanks again in advance.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    re: Help with conditional formatting:P3 to turn blue,

    - Select cell E3
    - Click Format - Conditional Formatting
    - select Formula Is
    - Enter in the formula box

    =$A$3="X"

    - define the format to apply
    - click ok

    Select E3 again
    - click the format painter icon
    - click on the next cell you want to have the same conditional format
    - repeat the format painter excercise for the other cells you want conditionally fomatted

    hth

+ 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