• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting for a table range

Wilco()

Member
How do I format a row in my table when a specific value is shown.

I have 3 columns:
a b c
1 Jack 2 YES
2 Jones 5 YES
3 Clair 3 NO

I want to highlight the row which has in column C YES.

I can manage for 1 line. It is possible to do this with 1 formula or should I enter this specifically for each row in my table?
 
dear wilco,

select the number of rows at column "C" and then go to conditional formatting>highlight cells rules>text that contains>YES>ok.
 
conditional formatting>new rule>use a formula to determine which cells to format>type =$c1="YES">select format>ok
next step
conditional formatting>manage rules>select the range of your table in the field applies to>ok
 
Back
Top