Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Colour
Hi everyone,
I have an excel spreadsheet that looks like this: Dr.A Dr.B Dr.C Total Wkld 100 100 100 Avail.Wkld Weight Amt Left Program A 100 Program B 100 Program C 100 So Avail. Wrkld and Amt Left gets populated when inside of the grid gets populated. If Avall Wkld is less than 0, I want to change the background colour to red. Same goes gor Amt Left. If it's greater than 0 then, just have the background colour as white. I am thinking of using the Worksheet_Change event. Can someone help me code this? Audrey *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Colour
You could simply use conditional formatting:
format / conditional formatting -----Original Message----- Hi everyone, I have an excel spreadsheet that looks like this: Dr.A Dr.B Dr.C Total Wkld 100 100 100 Avail.Wkld Weight Amt Left Program A 100 Program B 100 Program C 100 So Avail. Wrkld and Amt Left gets populated when inside of the grid gets populated. If Avall Wkld is less than 0, I want to change the background colour to red. Same goes gor Amt Left. If it's greater than 0 then, just have the background colour as white. I am thinking of using the Worksheet_Change event. Can someone help me code this? Audrey *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Colour
Audrey,
Why not use Conditional Formatting? Check help for details, and post back if you get stuck. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Audrey Ng" wrote in message ... Hi everyone, I have an excel spreadsheet that looks like this: Dr.A Dr.B Dr.C Total Wkld 100 100 100 Avail.Wkld Weight Amt Left Program A 100 Program B 100 Program C 100 So Avail. Wrkld and Amt Left gets populated when inside of the grid gets populated. If Avall Wkld is less than 0, I want to change the background colour to red. Same goes gor Amt Left. If it's greater than 0 then, just have the background colour as white. I am thinking of using the Worksheet_Change event. Can someone help me code this? Audrey *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Colour
Hi Bob and Andy,
Thanks for the quick reply. I have used Worksheet_Change function and that seems to work. My next problem is I need to be able to color the cell that has the highest rank. To be more specific, the previous post showed you a 'Schedule' worksheet. I have another sheet called 'Preferences' which ranks the program. If the Amt_Left = 0 on the Schedule worksheet, then that means that the user has finished putting all hours for that particular program and for each doctor. The program should then know to go to the next highest rank. I hope I'm making sense. Pleas ehelp. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Colour Pallett Changing........... | Excel Discussion (Misc queries) | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
Changing Cell Contents Colour | Excel Discussion (Misc queries) | |||
Changing a cell colour | Excel Discussion (Misc queries) | |||
changing cell colour on click | Excel Discussion (Misc queries) |