cell formatting

[Guest]

how to programatically format cell with color when contents meet conditions.
Example: =if cell A1="pass" highlight C1 (where the formula is) with Green,
and so on. and if condition does not come true leave the default or format as
per the user need. Appreciate your help.

 

[Guest]

Use Format > conditional formatting

Select C1 and go to Format>conditional formatting
Use Formula is and type in =A1="pass"
Click on the format button, go to the patterns tab, and choose green

 

[Guest]

You can do exactly what you have stated with Conditional Formatting, found
by clicking on FORMAT in the menu.