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: http://www.excelforum.com/member.php...o&userid=32977
View this thread: http://www.excelforum.com/showthread...hreadid=528047

Yes, the feature is called Conditional Formatting..........get there by doing
Format ConditionalFormatting and following the menu.....

Vaya con Dios,
Chuck, CABGx3



"crossbyname" wrote:


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: http://www.excelforum.com/member.php...o&userid=32977
View this thread: http://www.excelforum.com/showthread...hreadid=528047