Conditional Formatting

[Cook]

I would like cell B1 to strikethrough and the text turn red if cell C
equals FLOW THRU.

What is the formula i need to use in B1?

=c1="FLOW THRU"

If that is right when I change the drop down in C1 to FLOW THRU...
nothing happens.

Any thoughts

 

[T. Valko]

That's the correct formula.

Try following these steps:

Select cell B1
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=C1="flow thru"
Click the Format button
Select the Font tab
Set the Color to be RED
Select Strikethrough
OK out