Shade a cell on one wrksht if another wrksht cell is occupied

  • Thread starter Thread starter Guest
  • Start date Start date
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 Insert>Name>Define. 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 Format>Patterns and pick the color you want. Click OK and OK.

Does that help?

Steve
 
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?
 
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
 
Thanks guys, I got it to work!

Chip Pearson said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import data from 1 cell on 1 worksheet to othr cell(s) in another 1
Dynamic 5-week date range & SUMPRODUCT formulas 0
Need help please-SUMPRODUCT and Dynamic Range 11
If A1=dog or A2=cat in wrkbk1 sheet1, then copy row to wrkbk2 shee 11
Problem with SUMPRODUCT....help please! 5
VBA Code; need linked cells to change color if condition met 26
Same Formula, multiple columns, worksheets 1
Set a range on a variable sheet? 2

Back
Top