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?

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.


"TheStuff2007" wrote:

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?

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/excel2...l2007s6p2.html

If this post helps click Yes
---------------
Jacob Skaria


"TheStuff2007" wrote:

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?