Help with excel formula
[Closed]
Report
essentialbill
-
kathcat
kathcat
- Posts
- 27
- Registration date
- Tuesday October 21, 2008
- Status
- Member
- Last seen
- May 15, 2009
Related:
- Help with excel formula
- @ in excel formula ✓ - Forum - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- Excel formula bar missing - How-To - Excel
- Excel formula to transfer data between worksheets - How-To - Excel
- Excel formula copy rows based on criteria ✓ - Forum - Excel
1 reply
kathcat
- Posts
- 27
- Registration date
- Tuesday October 21, 2008
- Status
- Member
- Last seen
- May 15, 2009
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.
