Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Changing cell color with a formula?
39 views
Skip to first unread message
rogue...@yahoo.com
Aug 17, 2012, 11:06:56 PM8/17/12
to
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
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
lhki...@comcast.net
Aug 18, 2012, 9:59:06 PM8/18/12
to
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
lhki...@comcast.net
Aug 18, 2012, 10:12:54 PM8/18/12
to
On Friday, August 17, 2012 8:06:56 PM UTC-7, (unknown) wrote:
rogue...@yahoo.com
Aug 19, 2012, 5:06:26 AM8/19/12
to
Awe
Awesome!Using Excel 2003 but found everything as you described it under the formatting heading. Many, many thanks!
0 new messages