Conditional Formatting
 

I would like cell B1 to strikethrough and the text turn red if cell C1
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?


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65182

Conditional Formatting
 

That's the correct formula.

Try following these steps:

Select cell B1
Goto the menu FormatConditional 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

--
Biff
Microsoft Excel MVP


"Cook" wrote in message
...

I would like cell B1 to strikethrough and the text turn red if cell C1
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?


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65182