software

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 Insertgt;Namegt;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:

=Shadelt;gt;quot;quot;

Click Formatgt;Patterns and pick the color you want. Click OK and OK.

Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=544350Thanks Steve,

I named the cell quot;GroupNamequot; on the other worksheet. Can you tell me the
formula to achieve the following?

If the cell quot;GroupNamequot; 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?

quot;SteveGquot; wrote:

gt;
gt; You can use Conditional Formatting, you just have to Name the cell you
gt; want it to refer to. Say in Sheet1!A1, you want to apply the shading
gt; if Sheet2!A1 = something. Go to Insertgt;Namegt;Define. Type in a name
gt; for the reference to Sheet!2A1 ( I used Shade). Go to the cell you
gt; want to apply the CF to. Change the Cell Value is: option to Formula
gt; is then use something like:
gt;
gt; =Shadelt;gt;quot;quot;
gt;
gt; Click Formatgt;Patterns and pick the color you want. Click OK and OK.
gt;
gt; Does that help?
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=544350
gt;
gt;

In the Conditional Formatting dialog, change quot;Cell Value Isquot; to
quot;Formula Isquot;, and enter the following formula:

=LEN(GroupName)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Clarkquot; gt; wrote in message
news
gt; Thanks Steve,
gt;
gt; I named the cell quot;GroupNamequot; on the other worksheet. Can you
gt; tell me the
gt; formula to achieve the following?
gt;
gt; If the cell quot;GroupNamequot; has ANY text in it, I want a separate
gt; worksheet cell
gt; (call it A1) to fill in with a specific color. Does that make
gt; sense?
gt;
gt; quot;SteveGquot; wrote:
gt;
gt;gt;
gt;gt; You can use Conditional Formatting, you just have to Name the
gt;gt; cell you
gt;gt; want it to refer to. Say in Sheet1!A1, you want to apply the
gt;gt; shading
gt;gt; if Sheet2!A1 = something. Go to Insertgt;Namegt;Define. Type in
gt;gt; a name
gt;gt; for the reference to Sheet!2A1 ( I used Shade). Go to the
gt;gt; cell you
gt;gt; want to apply the CF to. Change the Cell Value is: option to
gt;gt; Formula
gt;gt; is then use something like:
gt;gt;
gt;gt; =Shadelt;gt;quot;quot;
gt;gt;
gt;gt; Click Formatgt;Patterns and pick the color you want. Click OK
gt;gt; and OK.
gt;gt;
gt;gt; Does that help?
gt;gt;
gt;gt; Steve
gt;gt;
gt;gt;
gt;gt; --
gt;gt; SteveG
gt;gt; ------------------------------------------------------------------------
gt;gt; SteveG's Profile:
gt;gt; www.excelforum.com/member.php...foamp;userid=7571
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=544350
gt;gt;
gt;gt;

Clark,

See Chip's post.Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=544350Thanks guys, I got it to work!

quot;Chip Pearsonquot; wrote:

gt; In the Conditional Formatting dialog, change quot;Cell Value Isquot; to
gt; quot;Formula Isquot;, and enter the following formula:
gt;
gt; =LEN(GroupName)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Clarkquot; gt; wrote in message
gt; news
gt; gt; Thanks Steve,
gt; gt;
gt; gt; I named the cell quot;GroupNamequot; on the other worksheet. Can you
gt; gt; tell me the
gt; gt; formula to achieve the following?
gt; gt;
gt; gt; If the cell quot;GroupNamequot; has ANY text in it, I want a separate
gt; gt; worksheet cell
gt; gt; (call it A1) to fill in with a specific color. Does that make
gt; gt; sense?
gt; gt;
gt; gt; quot;SteveGquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; You can use Conditional Formatting, you just have to Name the
gt; gt;gt; cell you
gt; gt;gt; want it to refer to. Say in Sheet1!A1, you want to apply the
gt; gt;gt; shading
gt; gt;gt; if Sheet2!A1 = something. Go to Insertgt;Namegt;Define. Type in
gt; gt;gt; a name
gt; gt;gt; for the reference to Sheet!2A1 ( I used Shade). Go to the
gt; gt;gt; cell you
gt; gt;gt; want to apply the CF to. Change the Cell Value is: option to
gt; gt;gt; Formula
gt; gt;gt; is then use something like:
gt; gt;gt;
gt; gt;gt; =Shadelt;gt;quot;quot;
gt; gt;gt;
gt; gt;gt; Click Formatgt;Patterns and pick the color you want. Click OK
gt; gt;gt; and OK.
gt; gt;gt;
gt; gt;gt; Does that help?
gt; gt;gt;
gt; gt;gt; Steve
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; SteveG
gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; SteveG's Profile:
gt; gt;gt; www.excelforum.com/member.php...foamp;userid=7571
gt; gt;gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=544350
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;


You're welcome.

Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=544350