Use Format conditional formatting

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


"GG" wrote:

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.