Highlight cells below specific value using Conditional Formatting

[Yamasaki450]

Hello guys.

I would like to highlight cells below specific value in column.

Example:
I have some random numbers in column A

Like this

1
5
8
3
4
8
7
2
8
1

Now i would like to highlight all numbers below number 8. In this case this would be 3,7 and 1

How can i do that using Conditional Formatting function?

Hope u know what i want and sorry for my English

Thanks.

 

[Fluff]

As this is a totally different question it needs a new thread. Thanks

 

[arthurbr]

Now i would like to highlight all numbers below number 8. In this case this would be 3,7 and 1

Yes, that is what my answer does

This will highlight all numbers smaller than 8... Thats not what i need... I want to highlight only first cell below all 8s in column.

This is entirely different...

 

[Fluff]

Yes, that is what my answer does

No it doesn't what you suggested will highlight all numbers below 8, not the cells directly below an 8.

This is entirely different...

The OP has already been told that.