software

how to programatically format cell with color when contents meet conditions.
Example: =if cell A1=quot;passquot; 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.

Use Format gt; conditional formatting

Select C1 and go to Formatgt;conditional formatting
Use Formula is and type in =A1=quot;passquot;
Click on the format button, go to the patterns tab, and choose greenquot;GGquot; wrote:

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

You can do exactly what you have stated with Conditional Formatting, found
by clicking on FORMAT in the menu.
--
Kevin Backmannquot;GGquot; wrote:

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