Improve Your Excel.com
Everything you need to improve your Excel in one place!
Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

Conditional Formatting

Conditional formatting allows you to set rules for cell formatting. If the rules (conditions) are met, then the formatting is applied. You can have up to 3 rules in a cell.

Conditional Formatting tips and tutorials.
  • Adding Ordinal Notation to Dates


  • Changing Coordinate Colors


  • Changing Font Face and Size Conditionally


  • Conditional Formats that Distinguish Blanks and Zeroes


  • Conditional Formatting Based on Date Proximity


  • Conditional Formatting for Errant Phone Numbers


  • Conditional Formatting with Data Imported from Access


  • Conditional Formatting


  • Conditionally Formatting for Multiple Date Comparisons


  • Copying Conditional Formatting


  • Highlighting Cells Containing Specific Text


  • More than Three Conditional Formats


  • Removing Conditional Formats, but Not the Effects


  • Shading a Cell Until Something is Entered


  • Shading Based on Odds and Evens


  • Shading Rows with Conditional Formatting


  • Sorting or Filtering by Conditional Format Results


  • Understanding Color and Conditional Formatting Codes


  • Understanding Conditional Formatting Conditions


  • Using AutoFormat


  • Using Multiple Test Conditions


  • Conditional Formatting


  • Duplicates in a Column - Conditional Formatting


  • More than Three Conditional Formats


  • Understanding Color and Conditional Formatting Codes


  • Use conditional formatting to identify above average scores in Excel


    • Want more tips? Subscribe to our Free Newsletter today and we will send them to you.
    Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros