Auto format rows according to field data

  • Thread starter Thread starter crossbyname
  • Start date Start date
C

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
 
Yes, the feature is called Conditional Formatting..........get there by doing
Format > ConditionalFormatting > and following the menu.....

Vaya con Dios,
Chuck, CABGx3
 
Back
Top