Help with excel formula
Closed
essentialbill
-
1 Mar 2009 à 04:11
kathcat Posts 27 Registration date Tuesday 21 October 2008 Status Member Last seen 15 May 2009 - 2 Mar 2009 à 05:33
kathcat Posts 27 Registration date Tuesday 21 October 2008 Status Member Last seen 15 May 2009 - 2 Mar 2009 à 05:33
Related:
- Help with excel formula
- Grade formula in excel marksheet - Guide
- Formula bar in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel formula - Guide
- Formula to calculate vat in excel - Guide
1 response
kathcat
Posts
27
Registration date
Tuesday 21 October 2008
Status
Member
Last seen
15 May 2009
2
2 Mar 2009 à 05:33
2 Mar 2009 à 05:33
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.