Conditional Formating


Posted by JohnS. on January 15, 2001 11:28 AM

I want cell A1 to be blue if B1 =true



Posted by Aladin Akyurek on January 15, 2001 11:59 AM

Select cell A1, activate Format, Conditional Formatting. Choose the option 'Formula is' Type

=B1=TRUE

and specify Font or Background as blue.

Aladin