ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Conditional Formatting (https://www.excelbanter.com/new-users-excel/50263-conditional-formatting.html)

mds310 via OfficeKB.com

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

Bob Phillips

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