# Little Excel help here **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [July 26, 2007, 5:35pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024 "2007-07-26T17:35:36Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![JDMAllstars](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@JDMAllstars](https://forums.speedlife.net/u/JDMAllstars)\ **Post date:** [July 26, 2007, 5:35pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/1 "2007-07-26T17:35:36Z")
ok so i wanna make a chart or something in excel to let someone know… alot of people actually that when a driving record comes back clean and i either type in a certain work like OK it will highlight the cell green for OK automatically and when i put in NO GO it will highlight the cell in red and when its pending it can highlight the cell in yellow or caution is there anyway to do this or no? if so a little point in the right direction would be appriciated ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [July 26, 2007, 5:43pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/2 "2007-07-26T17:43:53Z")
Yes there is a way to do this … I did it to a spread sheet I am doing … I’ll have to remember how to do it though ---
**Author:** ![JDMAllstars](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@JDMAllstars](https://forums.speedlife.net/u/JDMAllstars)\ **Post date:** [July 26, 2007, 5:46pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/3 "2007-07-26T17:46:03Z")
yeah that would be really siqqqq of you if you can help because its just alot easier for the intents and purposes i need it for ---
**Author:** ![articzap](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/articzap/32/7361_2.png) [@articzap](https://forums.speedlife.net/u/articzap)\ **Post date:** [July 26, 2007, 5:46pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/4 "2007-07-26T17:46:10Z")
[http://www.ozgrid.com/Excel/Formulas.htm](http://www.ozgrid.com/Excel/Formulas.htm) Look on there…Google is you friend. ---
**Author:** ![JDMAllstars](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@JDMAllstars](https://forums.speedlife.net/u/JDMAllstars)\ **Post date:** [July 26, 2007, 5:50pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/5 "2007-07-26T17:50:48Z")
i read all of that and it said nothing about typing in a word and color coding it for you it just would color code duplicate entries that was it ---
**Author:** ![articzap](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/articzap/32/7361_2.png) [@articzap](https://forums.speedlife.net/u/articzap)\ **Post date:** [July 26, 2007, 5:53pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/6 "2007-07-26T17:53:30Z")
ya so make a condition yes no pending on another sheet and have it transfer over to that column. ---
**Author:** ![JDMAllstars](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@JDMAllstars](https://forums.speedlife.net/u/JDMAllstars)\ **Post date:** [July 26, 2007, 5:57pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/7 "2007-07-26T17:57:40Z")
im asking you how i do that. if i knew how to do that this thread would have been pointless i need to know how to set up the condition and id like it to be on the same page so its easier to find instead of click on 3 different sheets say i enter something like this 543 blahblah no go = highlighted in red when the word no is entered 324 blah bla ok = red upon entering ok 342 eurewurwe pending = yellow upon entering pending or another word i choose thats what i am looking to do all on the same sheet ---
**Author:** ![Bacon](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/bacon/32/7230_2.png) [@Bacon](https://forums.speedlife.net/u/Bacon)\ **Post date:** [July 26, 2007, 7:41pm UTC](https://forums.speedlife.net/t/little-excel-help-here/33024/8 "2007-07-26T19:41:31Z")
Select your cells Format -\> Conditonal Formatting That should be able to do it for you. 🙂