| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shade a cell on one wrksht if another wrksht cell is occupied
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shade a cell on one wrksht if another wrksht cell is occupied
You can use Conditional Formatting, you just have to Name the cell you want it to refer to. Say in Sheet1!A1, you want to apply the shading if Sheet2!A1 = something. Go to InsertNameDefine. Type in a name for the reference to Sheet!2A1 ( I used Shade). Go to the cell you want to apply the CF to. Change the Cell Value is: option to Formula is then use something like: =Shade<"" Click FormatPatterns and pick the color you want. Click OK and OK. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=544350 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shade a cell on one wrksht if another wrksht cell is occupied
Thanks Steve,
I named the cell "GroupName" on the other worksheet. Can you tell me the formula to achieve the following? If the cell "GroupName" has ANY text in it, I want a separate worksheet cell (call it A1) to fill in with a specific color. Does that make sense? "SteveG" wrote: You can use Conditional Formatting, you just have to Name the cell you want it to refer to. Say in Sheet1!A1, you want to apply the shading if Sheet2!A1 = something. Go to InsertNameDefine. Type in a name for the reference to Sheet!2A1 ( I used Shade). Go to the cell you want to apply the CF to. Change the Cell Value is: option to Formula is then use something like: =Shade<"" Click FormatPatterns and pick the color you want. Click OK and OK. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=544350 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shade a cell on one wrksht if another wrksht cell is occupied
In the Conditional Formatting dialog, change "Cell Value Is" to
"Formula Is", and enter the following formula: =LEN(GroupName) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Clark" wrote in message ... Thanks Steve, I named the cell "GroupName" on the other worksheet. Can you tell me the formula to achieve the following? If the cell "GroupName" has ANY text in it, I want a separate worksheet cell (call it A1) to fill in with a specific color. Does that make sense? "SteveG" wrote: You can use Conditional Formatting, you just have to Name the cell you want it to refer to. Say in Sheet1!A1, you want to apply the shading if Sheet2!A1 = something. Go to InsertNameDefine. Type in a name for the reference to Sheet!2A1 ( I used Shade). Go to the cell you want to apply the CF to. Change the Cell Value is: option to Formula is then use something like: =Shade<"" Click FormatPatterns and pick the color you want. Click OK and OK. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=544350 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shade a cell on one wrksht if another wrksht cell is occupied
Clark, See Chip's post. Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=544350 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shade a cell on one wrksht if another wrksht cell is occupied
Thanks guys, I got it to work!
"Chip Pearson" wrote: In the Conditional Formatting dialog, change "Cell Value Is" to "Formula Is", and enter the following formula: =LEN(GroupName) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Clark" wrote in message ... Thanks Steve, I named the cell "GroupName" on the other worksheet. Can you tell me the formula to achieve the following? If the cell "GroupName" has ANY text in it, I want a separate worksheet cell (call it A1) to fill in with a specific color. Does that make sense? "SteveG" wrote: You can use Conditional Formatting, you just have to Name the cell you want it to refer to. Say in Sheet1!A1, you want to apply the shading if Sheet2!A1 = something. Go to InsertNameDefine. Type in a name for the reference to Sheet!2A1 ( I used Shade). Go to the cell you want to apply the CF to. Change the Cell Value is: option to Formula is then use something like: =Shade<"" Click FormatPatterns and pick the color you want. Click OK and OK. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=544350 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shade a cell on one wrksht if another wrksht cell is occupied
You're welcome. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=544350 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Shade Excell Cell | Excel Discussion (Misc queries) | |||
Linear Mode
