I believe Conditional Formatting will get you where you want to be:
Select the cells
FormatConditional Formatting
Condition 1: Cell Value is Equal to True
---set font color to green
Condition 2: Cell Value is Equal to False
---set font color to red
Click [OK]
Now just set those cells to Bold
Does that help?
Regards,
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=492161