Hi Gebobs,

Thank you very much for your help. It is really appreciated.

I will have to ask if it is possible to convert the text "numbers" to numbers.
I had a couple of other questions,

1) I need to apply the same rule to many rows (example, row 4 to 500), how would the formulas look like?

2) Also, it could be possible that two rules apply for the same cell. How does Excel manage those? Does it take only the first rule? Would it put the cell in two colors if I put different colors for each formula?

Thanks again!!