ReePrime
Blog DMC
Learn Excel – “Conditional Format the Row”: #1441

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

Learn Excel – “Conditional Format the Row”: #1441

B
Bill Jelen

323 Views • Oct 11, 2011

Description

Amal wants to highlight an entire record in red when the date falls within two weeks and then, leave the ‘Done’ column not marked as True. In Episode #1441, Bill shows us the tricky Conditional Formatting method to get the results we want.

Keywords & Tags

#2010 accounting Bill Jelen business conditional formatting Data Excel Formatting formula Functions MrExcel spreadsheets technology tutorial Worksheet

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

00:29

Mastering Conditional Formatting in Excel | Quick and Easy Guide | Learn Conditional Formatting in Excel | Color Coding and Data Visualization

Mr. EXCEL HACKS

00:46

How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks

ExcelTips247

05:26

Excel INFO : Search data in MS Excel with highlighting conditional formatting.

Excel INFO

09:23

Microsoft Excel 2016 Tutorial - Conditional Formatting in Excel

Mister Teeser

01:00

How do I alternate row colors in Excel conditional formatting? - Excel Tips and Tricks

ExcelTips247

01:00

How do I alternate column colors in Excel conditional formatting? - Excel Tips and Tricks

ExcelTips247