# Changing cell color with a formula?

roguegrafix@yahoo.com
Guest
Posts: n/a

 18th Aug 2012
Hi All,

I'm a teacher taking class attendance. I keep track of the students attendance in Excel. Every time they miss, I enter a "1" in their row. I have a total column keeping score (i.e summing up their row). Is there anyway I can get this total cell (or the adjacent cell) to change color (eg from no color to red)when they reach a certain score (eg when the total =5 the cell changes to red).

Steve
Thailand

lhkittle@comcast.net
Guest
Posts: n/a

 19th Aug 2012
On Friday, August 17, 2012 8:06:56 PM UTC-7, (unknown) wrote:
> Hi All,
>
>
>
> I'm a teacher taking class attendance. I keep track of the students attendance in Excel. Every time they miss, I enter a "1" in their row. I have a total column keeping score (i.e summing up their row). Is there anyway I can get this total cell (or the adjacent cell) to change color (eg from no color to red)when they reach a certain score (eg when the total =5 the cellchanges to red).
>
>
>
>
> Steve
>
> Thailand

Excel 2010.
Select cell
Under HOME click Conditional Fomatting
Click Highlight rules
Click Greater than
In the box enter 4
In the drop down to the left select th color
Click OK

Hope that helps.

Regards,Howard

lhkittle@comcast.net
Guest
Posts: n/a

 19th Aug 2012
On Friday, August 17, 2012 8:06:56 PM UTC-7, (unknown) wrote:
> Hi All,
>
>
>
> I'm a teacher taking class attendance. I keep track of the students attendance in Excel. Every time they miss, I enter a "1" in their row. I have a total column keeping score (i.e summing up their row). Is there anyway I can get this total cell (or the adjacent cell) to change color (eg from no color to red)when they reach a certain score (eg when the total =5 the cellchanges to red).
>
>
>
>
> Steve
>
> Thailand

Acually the color selection is to the right.

roguegrafix@yahoo.com
Guest
Posts: n/a

 19th Aug 2012
Awe

On Sunday, August 19, 2012 9:12:54 AM UTC+7, (unknown) wrote:
> On Friday, August 17, 2012 8:06:56 PM UTC-7, (unknown) wrote:
>
> > Hi All,

>
> >

>
> >

>
> >

>
> > I'm a teacher taking class attendance. I keep track of the students attendance in Excel. Every time they miss, I enter a "1" in their row. I have a total column keeping score (i.e summing up their row). Is there anyway I can get this total cell (or the adjacent cell) to change color (eg from no color to red)when they reach a certain score (eg when the total =5 the cell changes to red).

>
> >

>
> >

>
> >

>
> > Many thanks in advance.

>
> >

>
> > Steve

>
> >

>
> > Thailand

>
>
>
> Acually the color selection is to the right.

Awesome!Using Excel 2003 but found everything as you described it under theformatting heading. Many, many thanks!

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post glassman Microsoft Excel Worksheet Functions 1 12th Feb 2010 04:02 PM LATC Microsoft Excel Misc 6 4th Dec 2009 10:49 PM color transition Microsoft Powerpoint 2 21st Nov 2009 01:21 PM Jeff Klein Microsoft Excel Worksheet Functions 1 1st Nov 2007 09:59 PM mhax Microsoft Excel Programming 5 3rd Aug 2006 02:24 PM

Features