Excel Magic Trick 1106: 3-D Gradient Conditional Formatting For Row with AND Criteria

See how to add 3-D gradient conditional formatting to a row in a data set using the AND function to match student name and academic quarter.

Reference video for more about Conditional Formatting:

Highline Excel 2013 Class Video 12: AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT

[excelisfun]

Excel Magic Trick 1106: 3-D Gradient Conditional Formatting For Row with AND Criteria 

[livio]

Love those gradients, it adds quite some style to your workbook

[TimSheets]

I'm not usually a very stylish with my workbooks, but, this is pretty cool! Thanks for the tip!

[chowman]

Awesome Mike. Mike, i have a data sheet with multiple entries within a given date. what video would you advice me to watch that will help me extract n view records based on one criteria and perform a computation of addition for that particular date? Thanks again for your videos.

[mikenkiken]

Thanks for the video!
Could you do this with only one column for the AND condition? (Just wondering about the logic)

[chowman]

Mike, excuse me for my short comings...hope this will help regarding my previous request. My data sheet tabulates phone calls on a daily basis and gives me an idea of its duration, the cost of the call. The worksheet, thanks to you, is operational. Am able to get time stamps for each call, its duration, cost per call and total cost for the worksheet. I would like to basically add a feature by which am able to view (if I choose to), the calls, duration, cost for a particular date. Lets say I had 180 calls between 4/1 - 4/15 and if I want to view how many calls I got in 4/4, I would just indicate by a pull down menu. Can I send you the worksheet?