Auto format rows according to field data
 

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

Auto format rows according to field data
 

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