Help with excel formula [Closed]

Question

Help with excel formula [Closed]

Report

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

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

Help with excel formula
Excel formula bar missing - How-To - Excel
Excel formula to transfer data between worksheets - How-To - Excel
Excel formula @ symbol ✓ - Forum - Excel
Excel formula for position ✓ - Forum - Office Software
Excel formula for debit credit balance - How-To - Excel

1 reply

Ask a question

kathcat · Answer 1 · 2009-03-02T05:33:06-0500

Answer 1 / 1

kathcat

Posts: 27
Registration date: Tuesday October 21, 2008
Status: Member
Last seen: May 15, 2009

2
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.

Help with excel formula [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!