highlighting of cells that do not fit certain parameters

[illinifan1]

I can not remember the "name" of this feature to look it up in the book. I've got a bunch of gas receipts that I'm auditing and I want to highlight purchases on weekends and outside of work hours. What formula can i use to quickly highlight these kinds of purchases?

I'm having a hard time figuring out how to copy an example.... but i have a spreadsheet that has dates/times of all purchases (among other things) and want to "heat map" things outside of work hours - i'm going to now consult my Power Excel book for heat mapping while I eagerly await someones help.

Thanks in Advance!

 

[Joe4]

Welcome to the Board!

I think you are looking for "Conditional Formatting".

 

[illinifan1]

thanks - I had an old username - but couldn't reset the password since it was associated with my prior employer's email. That said, I appreciate the assistance!

Have a great day - there is nothing under "heat mapping" in the Power Excel - but i'm consulting Conditional formatting now. Have a great day and thanks again!

 

[illinifan1]

This worked great - for looking at TIMES outside of business hours - i'm having a difficult time doing the same with days of the week? (identifying weekends)

 

[illinifan1]

I tried to respond to your private message - here's the error that I received?

[h=3]The following errors occurred with your submission[/h]

• You have reached your stored private message quota and cannot send any further messages until space has been created.