Help with excel formula
Closed
essentialbill
-
Mar 1, 2009 at 04:11 AM
kathcat Posts 27 Registration date Tuesday October 21, 2008 Status Member Last seen May 15, 2009 - Mar 2, 2009 at 05:33 AM
kathcat Posts 27 Registration date Tuesday October 21, 2008 Status Member Last seen May 15, 2009 - Mar 2, 2009 at 05:33 AM
Related:
- Help with excel formula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
1 response
kathcat
Posts
27
Registration date
Tuesday October 21, 2008
Status
Member
Last seen
May 15, 2009
2
Mar 2, 2009 at 05:33 AM
Mar 2, 2009 at 05:33 AM
hi,
you need to use "Conditional formatting".
select all your text (number of hours), click on "Conditional formatting", "highlight cells rules", "Greater than..." then add the number you want (3000) and select the formatting you want.
you need to use "Conditional formatting".
select all your text (number of hours), click on "Conditional formatting", "highlight cells rules", "Greater than..." then add the number you want (3000) and select the formatting you want.
