Conditional Formatting - Assistance Please :(

K

khenry

I'm setting up an excel sheet in Microsoft Excel 2010 and I'm in need o
assistance.

Column D holds Priority: Medium or High
Column B holds Ticket Date and Time
Column E holds Response Time

Column F however, holds response time in hours.
This is where I need the assistance.

I'd like to get a calculatedresult for this column. Taking away th
response time from the ticket date and time.
I'd also like to produce some sort of color code for this column.
Eg:
If Medium, then Response time<8 - turn cell green
else, turn cell red
If High, then Response time<4 - turn cell green
else, turn cell red.

Really hope I can get some assistance. Still spending some time with i
at the moment
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Conditional Formatting 4
Excel 2010 Conditional Formatting 2
Conditional Formatting 2
Conditional Formatting - Cannot get it to work, please help 1
Conditional Format Tracker by Date 0
Conditional Formatting and cloring cells and date calculations 1
Conditional formatting-Date range 1
Using colour conditional formatting to show whether due date has past 0

Top