This is the demonstration file to accompany the article, How to use the selected value in a combo to determine conditional formatting in Excel, by Susan Harkins. From the hottest programming ...

This Excel file contains Name, Mobile# , DOB, Subject and Marks in % for each students. So I have created a Data Validation for Mobile No.- Will accept only 10 Digit Numbers between 7000000000 & ...

In that article, "Use Excel's conditional formatting to highlight weekends," we created the sheet shown in Figure A. By separating the year, month, and day, you can reuse the same sheet. This ...

Sample file: How to avoid a conditional formatting rule that doesn’t work as expected Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.