Conditional Formating Home Board Archive Index Excel Formulas 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