![]() |
Conditional Formatting
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 |
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 |
All times are GMT +1. The time now is 04:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com