Conditional formating in Excel 2007?

Question

I have a excel question that seems easy enough but I can’t figure it out.

Ok imagine I have data in Column B such as names:

Brian Brown

David Jones

Etc.

Etc.

Then in column C I have a column CALLED “PICKED”

So I would put a “X” in the column.

So what I want to happen is

If(C2=”x”)

Conditional format to

B2 text as red and strike through.

But I can’t figure it out.

It never works.

Any advice?

Answer 1

what part are you having a problem with?

i will just go through the click by click:

- i highlighted the imaginary B column

- click the big conditional formatting button

- click "new rule"

- click "use formula to determine which cells to format(its last on the list)

- copy&paste this formula in the box

=c2="X"

- click Format... (this should put you in font tab)

- click to change color from automatic to red

- click a checkmark next to strikethrough

- click ok a few times

and it should just work.