Share via

Conditional formatting for a column based on the contents of another column

Karla Marciszewski 20 Reputation points
2024-07-08T16:15:30.9666667+00:00

I am trying to format font and/or background for the cells in one column based on the content of the associated cell in another column. I can get it to work if I do it cell by cell but have no desire to set of the conditions individually for each cell. Screenshot 2024-07-08 103719.png

I want to format the second column showing based on the content in the 3rd column. Screenshot 2024-07-08 120912.png

I set of the conditions pictured, but this does not work. Any ideas would be appreciated.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,447 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
0 comments
Accepted answer
  1. Barry Schwarz 2,506 Reputation points
    2024-07-08T22:27:42.28+00:00

    The range of cells in the formula must be "compatible" with the range of cells the formula is applied to. The text value must be in quotes.

    Change the formula in the first rule from

    =$D:$D=Rare

    to

    =$D$3:$D$1175="Rare"

    Make similar changes to the other rules.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest