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.