Auto format rows according to field data

[crossbyname]

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

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

Thanks in advace
Ti

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3