Change font color base on a value

Anybody can help me to this problem ??

if i input NO. "1" value on cell "B1"
The font Color on "C1" will change to color red

and when i input No. "2" The Font Color will change to color "BLUE"

Thanks, Godbless..

jason, you need to wait at least a day before "bumping" your thread, and certainly more than 20 minutes

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =B1=1 FORMAT fill RED

repeat this for BLUE

Put this in the worksheet change event for your workbook

Please Login or Register  to view this content.