Format-> Conditional Formatting is your friend The easiest thing to do is to select the first box (B2 if I'm reading your cheat sheet right) and do the following
Format-> Conditional Formatting Choose Cell Value Is from the first drop down Choose Equal To from the second drop down Type "=B$1" in the third section (no quotes) The $ is critical because the next step is to copy that cell and highlight the whole region you want to do that in and choose "Paste Special" and "Formats"... This will make all cells have that conditional format but anchored correctly (the column reference will move left and right but it will always reference row 1 Hope that helps --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
