locked
Conditional Formatting question RRS feed

  • Question

  • Hello,

    I was wondering if someone could help,

    In the range: C8:BW125, each individual cell contains a different value.

    I wish to conditionally format all the cells in that range that contain the same value as cell E3.

    In other words, whatever value is in cell E3, the matching cells in C8:BW125 will be formatted.

    Can someone please help?

    Thanks,

    Pete

    Thursday, April 23, 2015 5:52 PM

Answers

  • Hi,

    In the menu Home > Conditional Formatting > choose option new rule > choose option format only cells that contain. See below screenshots.

    Fill in E3 in the cell next to equal to.

      

    In the field applies to: fill in C8:BW125.

    Regards,

    Reshma


    Please Vote as Helpful if an answer is helpful and/or Please mark Proposed as Answer or Mark As Answer when question is answered

    • Marked as answer by pete6256 Thursday, April 23, 2015 6:18 PM
    Thursday, April 23, 2015 6:16 PM

All replies

  • Hi,

    In the menu Home > Conditional Formatting > choose option new rule > choose option format only cells that contain. See below screenshots.

    Fill in E3 in the cell next to equal to.

      

    In the field applies to: fill in C8:BW125.

    Regards,

    Reshma


    Please Vote as Helpful if an answer is helpful and/or Please mark Proposed as Answer or Mark As Answer when question is answered

    • Marked as answer by pete6256 Thursday, April 23, 2015 6:18 PM
    Thursday, April 23, 2015 6:16 PM
  • Thanks!
    Thursday, April 23, 2015 6:17 PM
  • You are welcome!

    Please Vote as Helpful if an answer is helpful and/or Please mark Proposed as Answer or Mark As Answer when question is answered

    Thursday, April 23, 2015 6:21 PM