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.

OK It worked but I added in as a conditional format. They all reference the same cell. So if the first row matches the condition then whole table gets formatted else none of them gets formatted. How do I make it so each row references its rows coll — User
– User, Commented Dec 7, 2018 at 18:19
Then you did not use the formula as I stated. the row must be relative not absolute. — Scott Craner
– Scott Craner, Commented Dec 7, 2018 at 18:19

Scott Craner · Accepted Answer · 2018-12-07 18:21:27Z

2

Use:

=$A1="YES"

As the formula and apply it to Column C

answered Dec 7, 2018 at 18:21

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

User Over a year ago

What I did was I used the formula =$W$2="YES". I applied this to the whole column. But what happens is if $W$2 is YES then all of col c gets formatted.

User Over a year ago

Maybe its because the table is already created so it doesn't auto increment?

Scott Craner Over a year ago

As stated the row must be relative: =$W2="YES"

Collectives™ on Stack Overflow

Excel conditional formatting

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related