software

I have a sheet with a column that will have a value of either R, A, or G
(standing for red, amber, green) depending on its status.

Is there way of creating a script that will automatically format the
text colour of the row to red, green or amber depending on what value
is entered in the RAG column?

Thanks in advace
Tim--
crossbyname
------------------------------------------------------------------------
crossbyname's Profile: www.excelforum.com/member.php...oamp;userid=32977
View this thread: www.excelforum.com/showthread...hreadid=528047Yes, the feature is called Conditional Formatting..........get there by doing
Format gt; ConditionalFormatting gt; and following the menu.....

Vaya con Dios,
Chuck, CABGx3
quot;crossbynamequot; wrote:

gt;
gt; I have a sheet with a column that will have a value of either R, A, or G
gt; (standing for red, amber, green) depending on its status.
gt;
gt; Is there way of creating a script that will automatically format the
gt; text colour of the row to red, green or amber depending on what value
gt; is entered in the RAG column?
gt;
gt; Thanks in advace
gt; Tim
gt;
gt;
gt; --
gt; crossbyname
gt; ------------------------------------------------------------------------
gt; crossbyname's Profile: www.excelforum.com/member.php...oamp;userid=32977
gt; View this thread: www.excelforum.com/showthread...hreadid=528047
gt;
gt;