# Microsoft Excel Question

**URL:** https://forums.speedlife.net/t/microsoft-excel-question/36955
**Category:** NYSpeed Off Topic
**Created:** [October 14, 2007, 8:41am UTC](https://forums.speedlife.net/t/microsoft-excel-question/36955 "2007-10-14T08:41:00Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Poose22](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/poose22/32/7252_2.png) [@Poose22](https://forums.speedlife.net/u/Poose22)
#### Post date: [October 14, 2007, 8:41am UTC](https://forums.speedlife.net/t/microsoft-excel-question/36955/1 "2007-10-14T08:41:00Z")

</div>

im creating an if statement and im wondering if this is even possible cus i cant even find an answer on google. the statement is basically: if the value is true, then strikethrough a range of different cells. i cant seem to find a way to strikethrough the cell though. im not sure if it’s possible. let me know if anyone knows how. thanks

---

<div class="post-metadata">

### Author: ![Ovrwrkd](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ovrwrkd/32/7586_2.png) [@Ovrwrkd](https://forums.speedlife.net/u/Ovrwrkd)
#### Post date: [October 14, 2007, 8:42am UTC](https://forums.speedlife.net/t/microsoft-excel-question/36955/2 "2007-10-14T08:42:12Z")

</div>

Conditional formatting of the cell maybe? Been awhile since I’ve done this kind of work with Excel.

---

<div class="post-metadata">

### Author: ![Poose22](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/poose22/32/7252_2.png) [@Poose22](https://forums.speedlife.net/u/Poose22)
#### Post date: [October 14, 2007, 8:44am UTC](https://forums.speedlife.net/t/microsoft-excel-question/36955/3 "2007-10-14T08:44:46Z")

</div>

[quote=“Itagaki,post:2,topic:36955"”]

Conditional formatting of the cell maybe? Been awhile since I’ve done this kind of work with Excel.

[/quote]

thought of that, but i need a range of many different cells to strikethrough if the value is true. and conditional formatting wont go the distance.

---

<div class="post-metadata">

### Author: ![redrum](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/redrum/32/7398_2.png) [@redrum](https://forums.speedlife.net/u/redrum)
#### Post date: [October 14, 2007, 10:25am UTC](https://forums.speedlife.net/t/microsoft-excel-question/36955/4 "2007-10-14T10:25:02Z")

</div>

I dont think anything other than conditional formatting will do it. You’re either going to have to go through all the cells and apply the conditional formatting to them all, or think of another way to convey that those numbers shouldnt be used in lieu of the strikethrough.

---

<div class="post-metadata">

### Author: ![Poose22](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/poose22/32/7252_2.png) [@Poose22](https://forums.speedlife.net/u/Poose22)
#### Post date: [October 14, 2007, 11:45am UTC](https://forums.speedlife.net/t/microsoft-excel-question/36955/5 "2007-10-14T11:45:05Z")

</div>

thanks guys

---

<div class="post-metadata">

### Author: ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)
#### Post date: [October 14, 2007, 12:27pm UTC](https://forums.speedlife.net/t/microsoft-excel-question/36955/6 "2007-10-14T12:27:45Z")

</div>

macros… k bye google it
