Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting using color based on another cell
Spent the last 2 hours looking around for the answer and figured Id just come
to the experts. I want to make a simple spreadsheet to track the progress of a disaster recovery visually. In column A lets say I have a list of servers In column C I have a subset of the servers that are just database servers In column E I have another subset of servers that make up an application In column G I have a list of applications Id like my Unix team to be able to mark each server complete as they recover them. Lets say they highlight the cell green to do this. I then want the same servername in column C to turn from dark grey to no fill once it is marked green in Column A. This signifies the database team they can do a checkout on the server. They mark it complete by again setting the fill to Green. I then want the same servername to light up green in column E showing me which servers of each application have been recovered. When all of the servers have been recovered for a given application, I want the application name in column G to light up green. I figure this is simple conditional formatting formulas but I cant figure it out easily and I know someone here can do it right off the top of their head. So, thanks in advance. If you like, you could send a sample to Thanks, -- Michael Gwin Program Director UnitedHealth Group |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting using color based on another cell
No action yet? Gonna make me do the homework myself eh? :)
-- Michael Gwin Program Director UnitedHealth Group "Michael Gwin" wrote: Spent the last 2 hours looking around for the answer and figured Id just come to the experts. I want to make a simple spreadsheet to track the progress of a disaster recovery visually. In column A lets say I have a list of servers In column C I have a subset of the servers that are just database servers In column E I have another subset of servers that make up an application In column G I have a list of applications Id like my Unix team to be able to mark each server complete as they recover them. Lets say they highlight the cell green to do this. I then want the same servername in column C to turn from dark grey to no fill once it is marked green in Column A. This signifies the database team they can do a checkout on the server. They mark it complete by again setting the fill to Green. I then want the same servername to light up green in column E showing me which servers of each application have been recovered. When all of the servers have been recovered for a given application, I want the application name in column G to light up green. I figure this is simple conditional formatting formulas but I cant figure it out easily and I know someone here can do it right off the top of their head. So, thanks in advance. If you like, you could send a sample to Thanks, -- Michael Gwin Program Director UnitedHealth Group |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting using color based on another cell
On Oct 17, 8:07*am, Michael Gwin
wrote: No action yet? *Gonna make me do the homework myself eh? *:) -- Michael Gwin Program Director UnitedHealth Group "Michael Gwin" wrote: Spent the last 2 hours looking around for the answer and figured Id just come to the experts. I want to make a simple spreadsheet to track the progress of a disaster recovery visually. In column A lets say I have a list of servers In column C I have a subset of the servers that are just database servers In column E I have another subset of servers that make up an application In column G I have a list of applications Id like my Unix team to be able to mark each server complete as they recover them. Lets say they highlight the cell green to do this. I then want the same servername in column C to turn from dark grey to no fill once it is marked green in Column A. *This signifies the database team they can do a checkout on the server. *They mark it complete by again setting the fill to Green. I then want the same servername to light up green in column E showing me which servers of each application have been recovered. *When all of the servers have been recovered for a given application, I want the application name in column G to light up green. I figure this is simple conditional formatting formulas but I cant figure it out easily and I know someone here can do it right off the top of their head. So, thanks in advance. *If you like, you could send a sample to Thanks, -- Michael Gwin Program Director UnitedHealth Group- Hide quoted text - - Show quoted text - Michael, I can not find any references to formatting depending on format of an other cell. You could get your technicians to enter a value ( for example 1 ) into the cell next to the server you want to highlight green That same value could then determine the colour in the other servers or applications etc. Greetings from NZ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Sum Based on Cell Background Color | Excel Worksheet Functions | |||
Conditional Formatting based in cell color | Excel Discussion (Misc queries) | |||
Conditional Formatting (Excel 2007) Format Row Color Based on X | Excel Discussion (Misc queries) | |||
Find cells w/background color based on conditional formatting | Excel Worksheet Functions | |||
Change Font Color Based on Conditional Formatting | Excel Worksheet Functions |