Question about Microsoft Office Standard for PC
I need some help with formating a spreadsheet. I need column "a" to reflect the time it take to solve a query, if its longer that 03:00 to change colour to red. if the query is complete for the column to have no colour.
I have dropdowns on the spreadsheet. i also want colour to change when a certain status was selected and it took longer that 24:00 to also change but when its complete to change to no colour.
In Excel 2007 and if you have a cell (say C2) with the value of elapsed time (for example set = A2 which contains start time plus B2 which contains end time - or current time) - click in the cell (C2) then on the Home tab click on Styles >> Conditional formatting choose Highlight Cells Rules>>Greater Than... set your value in the dialog to your respective value and choose your highlight. This is a start - you can then add new rules.
to then apply this same conditional formatting to every cell in that column Ctrl-C to copy the cell you just formatted - then click on the column header to highlght the entire column - Right-click and choose Paste Special - then choose Formatting for what to paste.
It's slightly different in Excel 2003 so let us know what version you are using.
Posted on Mar 21, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 06, 2016 | Casio Office Equipment & Supplies
Sep 16, 2014 | Microsoft Excel for PC
Jan 09, 2013 | Microsoft Excel Computers & Internet
Aug 02, 2009 | Microsoft Office Excel 2007
May 31, 2009 | Apple Office Equipment & Supplies
Apr 27, 2009 | Computers & Internet
Feb 02, 2009 | Microsoft EXCEL 2004 for Mac
Nov 20, 2008 | Microsoft Excel for PC
Apr 04, 2008 | Microsoft Excel for PC
113 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: