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
Hello,
i am working on a spreadsheet that keeps track of machine hours. i need help with a formula that when themachine hours gets to 3000. the numbers turn red. thank you
Related:

1 response

kathcat Posts 27 Registration date Tuesday 21 October 2008 Status Member Last seen 15 May 2009 2
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.