Excel conditional formatting

Question

I was hoping someone can help me with a formula.

What I am trying to do is format a number as currency if the column 3 to its left contains a specific text.

For example,

Col1, Col2, Col3
YES   a     5$
NO    b     4
YES   c     3$

In this case 5 and 4 are formatted as currency since their corresponding Col1 is YES.

Answer 1

Use:

=$A1="YES"

As the formula and apply it to Column C