Conditional Formatting

[TheStuff2007]

I'm trying to make a conditional formatting rule in Excel 2007 that makes a
row of several cells where one cell contains the text "Yes" to be formatted
to have strike-through active. Can anyone explain to me how to do this?

 

[Warren Easton]

Hi,

Highlight the cells you want to condition.
Click on Conditional Formatting icon in the styles area.
Click on New Rule. In the Select a Rule Type: area choose “Use a formula to
determine which cells to formatâ€.
When the Date is in say cell A1 write the following formula in the Format
values where this formula is true: =$A$1=â€Yes†then click on format and then
strikethrough in the effects area.
Click OK twice.

--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.

 

[Jacob Skaria]

From-New Formatting Rule window
Select -->Format only cells that contain
Enter Yes with drop downs Cellvalue-->equal to
Format it to strike through

Please refer the link for more help

http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html

If this post helps click Yes