Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I use excel for a marksheet. A level my students 1, 2, 3, 4.
When I put a "4", for example, I usually go to format and then colour the cell blue. I was wondering if there was a way that Excel automatically changes the cell colour from "standard" to "blue" when I enter 4. and then for "3" I would get "green" etc. I know about the format painter icon which saves time, but i was wondering if there was a faster way ... thanks |
#2
![]() |
|||
|
|||
![]() Good morning Spags There is a quicker way, Conditional Formatting under the format menu. Unfortunately, it can only hold three conditions, so you would have to have colours set up for marks 1,2 and 3 and leave 4 as the blank white colour. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=401653 |
#3
![]() |
|||
|
|||
![]()
You don't have to have the default as white, colour all the cells a colour,
and set the 3 conditions for other colours. Voila, 4 colours. -- HTH RP (remove nothere from the email address if mailing direct) "dominicb" wrote in message ... Good morning Spags There is a quicker way, Conditional Formatting under the format menu. Unfortunately, it can only hold three conditions, so you would have to have colours set up for marks 1,2 and 3 and leave 4 as the blank white colour. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=401653 |
#4
![]() |
|||
|
|||
![]()
Thanks to both responses! You saved me at least 5 minutes every time I
record marks! I'm ready for the beginning of the school year! Cheers! Spags! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I'm loosing colour when copying charts from excel to word. | Charts and Charting in Excel | |||
Counting cells in Excel? | Excel Discussion (Misc queries) | |||
EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
merging cells excel 2003 | Excel Discussion (Misc queries) |