# Excel NerdS Enter - Conditional Formatting

**URL:** <https://forums.speedlife.net/t/excel-nerds-enter-conditional-formatting/33683>\
**Category:** NYSpeed Off Topic\
**Created:** [August 10, 2007, 7:12am UTC](https://forums.speedlife.net/t/excel-nerds-enter-conditional-formatting/33683 "2007-08-10T07:12:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [August 10, 2007, 7:12am UTC](https://forums.speedlife.net/t/excel-nerds-enter-conditional-formatting/33683/1 "2007-08-10T07:12:27Z")

</div>

Ok

So i have a spreadsheet that is tracking a very long process

I have several rows for each item to be processed and each column is a process

I have everything setup but the conditional format. I have the condition written correctly i think(its setup to work “if value = change color red” bla bla bla.

i want to be able to quickly copy and paste my conditional format across a 5x25 table so i can change the status with color changes. my problem is after I copy and paste the condition references the host cell that I copied… so if i change the host cell status, the destination cell that I copied to changes…

Help

---

<div class="post-metadata">

**Author:** ![BuickGN](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/buickgn/32/7200_2.png) [@BuickGN](https://forums.speedlife.net/u/BuickGN)\
**Post date:** [August 10, 2007, 7:16am UTC](https://forums.speedlife.net/t/excel-nerds-enter-conditional-formatting/33683/2 "2007-08-10T07:16:28Z")

</div>

u get that stuff i sent u?

---

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [August 10, 2007, 7:17am UTC](https://forums.speedlife.net/t/excel-nerds-enter-conditional-formatting/33683/3 "2007-08-10T07:17:30Z")

</div>

ya i got it…

and my host cell was messed. its easy… just use the format painter.

my host cell had bad formatting data in it.

:ham2:

---

<div class="post-metadata">

**Author:** ![BuickGN](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/buickgn/32/7200_2.png) [@BuickGN](https://forums.speedlife.net/u/BuickGN)\
**Post date:** [August 10, 2007, 7:24am UTC](https://forums.speedlife.net/t/excel-nerds-enter-conditional-formatting/33683/4 "2007-08-10T07:24:05Z")

</div>

ok cool