Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |