Just use CF with a greater than value. Set that value to your threshold and
set a pattern colour.

--
HTH

Bob Phillips

"mds310 via OfficeKB.com" <u14855@uwe wrote in message
news:55c823bdb4b96@uwe...
I'm hoping someone will be able to assist. I have a spreadsheet that
tracks
hours. I need to be able to quickly identify if I'm close to or have
reached
a certain number. Was hoping for a conditional formula that will change
the
color and or font of the value once it reaches my pre-determined number.

Thanks!
Monica