Highlight All Columns in your Data Set using Conditional Formatting.
Conditional Formatting or Data Validation…? Which would work for you?
Dueling Excel takes a look at Creating Data Bars in a variety of ways in Excel 2010 and earlier.
Dueling Excel Takes on Conditional Rounding Duties . . .
“Would the *real* Unique Value please Highlight!”