Excel - Help please

  Allan-263226 12:06 19 Nov 03
Locked

Hi, I hope i can explain this correctly.....

I have created a spreadsheet where I enter fault details, time logged, date, etc.....
I work to a 4 hour SLA, therefor I need the rows to highlight in Orange when they are at 3 hours and red when at 4.

Is there a macro needed or can I set a formula (don't think I can) that I can add to make the rows highlight

  scotty 12:11 19 Nov 03

I think conditional formating might work.

Will have a look (but I expect VOG to give a reply before I do!)

  Allan-263226 12:15 19 Nov 03

Ok cheers Scotty

  VoG II 12:21 19 Nov 03

Yes, Format/Conditional formatting.

Say your time is in A1. Then in B1 apply conditional formatting using "Formula Is" and making the formula

=A1=3

and choose orange color.

Then apply a further condition

=A1=4

and colour it red.

Then use the Format Painter (paintbrush) to apply to the entire row, and as many rows down as you need.

I suggest that you lookup Conditional Formatting in Help for more information.

  scotty 12:34 19 Nov 03

The answer is......

**** - too late!

  Allan-263226 12:47 19 Nov 03

Cheers guys, all sorted

This thread is now locked and can not be replied to.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…