Please ur urgent help is highly appreciated

August 3, 2009 at 02:51:56
Specs: Windows XP
i have a spreadsheet file,which we use it as IT service desk log.what i need to do is to check the technicians who are not finishing their work in the specified time.i have two date columns,call_date and closing_date.i want to compare the two(closing_date minus call_date).if the result is greater than 2,then the row color has to change to red.i want it to be done sheet wise instead of row wise.

thanking you in advance

See More: Please ur urgent help is highly appreciated

Report •

August 3, 2009 at 04:08:31
I'll offer a suggestion below, but first a couple of posting tips.

1 - Your subject line should be more than a request for help. It should be relevant to the question in your post. e.g. "Change Excel cell color" or something like that.

2 - Using words like "urgent" is not going get you an answer any quicker. People will respond to your post when they can, if they can, and aren't going to answer your post first just because you use "urgent" in the subject. You might even turn a few people off by implying that your question is more important than somebody else's.

3 - re: i want it to be done sheet wise instead of row wise.

I don't know what you mean by that. If the answer below doesn't help, please explain further.

Finally, look at the Help files on "Conditional Formatting".

Format...Conditional formatting.

Select the cells you want to format.

Pull down Condition 1 and choose "Formula is..."

Enter this in the field, modifying the cell references as required:

=IF($B1-$A1>2, TRUE, FALSE)

Click Format...Pattern tab..choose a color.

OK your way out.

Report •
Related Solutions

Ask Question