Change font style based on value in column C

[Aussiebear]

I am looking for code that enables the active row to change the font format providing the value of the cell in column c = Yes.

Currently the value in column c is boolean in function ( either Yes or No). I am using the following formula to determine its value:
=If(B2=" "," ",IF(K2=" "," ",IF(I2>H2,"Yes","No")))
Normal font for the active row is Arial, Bold and Dark Blue when the value is "No". I am hoping that once the value is "Yes", then the font is Arial, Non bold & Grey.

How do I do this?

 

[DonkeyOte]

Also you could streamline your formula in C2 to

=IF(OR(B2=" ",K2=" ")," ",IF(I2>H2,"Yes","No"))

What happens to previously active rows when you change row -- should prior rows that were formatted differently change back to default ?

(like a row highlight or are you trying to highlight all rows that have C = Yes on an incremental basis...confused)

 

[Andrew Poulsom]

Select row 2 and choose Format|Conditional Formatting from the menu. Condition 1 Formula is:

=$C2="Yes"

choose a Format and click OK twice.

 

[Aussiebear]

Thank you Andrew. I will try this at work tomorrow.

lasw10, Thank you as well. Basicily once a Contract is closed, the value in column c turns "yes" and remains this way. Sorry if I was confusing in my post.

 

[Aussiebear]

Andrew, in thinking about this a little further, how do i create this effect over a number of rows? Do I need to create a conditional format per row or create code to do so?

 

[Andrew Poulsom]

You can select all the rows and use my formula, provided that row 2 is the active row when you enter it.

 

[Aussiebear]

Okay, thank you for your assistance