Conditional format or macro?

[otrevino3]

For the entire sheet...

If the value of A1 starts with "***", format the entire row with a green font
If the value of A1 starts with "**", format the entire row with a red font
Else leave font as is.

thx

 

[NBVC]

Select whole sheet

Go to Format|Conditional Formatting

Select Formula Is from drop down

=LEFT($A1,3)="***"... then you click format and pick green

=LEFT($A1,2)="**"....format red

 

[otrevino3]

THANKS!