Help with excel formula [Closed]

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

1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!