Reputation:

how to highlight cells that match given criteria

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

Upvotes: 1

Answers (3)

NoahD

Reputation: 8302

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.

Upvotes: 0

zeroDivisible

Reputation: 4130

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

Upvotes: 2

shahkalpesh

Reputation: 33474

Conditional Formatting is what you are looking for.

Upvotes: 3

how to highlight cells that match given criteria

Answers (3)

Related Questions