how to highlight cells that match given criteria

Question

i have tons of data that i would like to highlight only those cell that fulfill some criteria, said value < 0.100. Please advice.

Answer 1

Conditional Formatting is what you are looking for.

Answer 2

You can use conditional formatting. ( More info here, tutorial here and a video tutorial on YouTube.)

Answer 3

The above answers are correct, but I would add that if I recall correctly you can have unlimited conditional formatting on the same cell(s) in Excel 2007, but only three conditions pre-Excel 2007.