Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional formatting based on cell other than on (2002)

    Conditional formatting for a cell works on the values or formulas in the cell being formatted. I have a different problem. I want to format a cell based on the value in a *different* cell. For example, if the cell to be formatted conditionally is A2, I want it to be red if cell B3 contains the string "Y". Can this be done without a macro or without programming?

    Thanks,

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional formatting based on cell other tha

    This can be done with conditional formatting, it can check the value of another cell.

    Set up conditonal formatting in cell A2 and use the "Formula is" option. In the formula box enter the following formula:
    =B3="Y"

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting based on cell other tha

    Thanks. That worked just fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •