Conditional Formttg question

[MikeyZ]

In O10 I set a conditional format as follows:
=O10>N10
Change the Font to a red color.
Then I click on the PaintBrush to set the format for the rest of the 5000 lines.

When I go to O11 to check the format it says =O11>N11.
When I go to O12:O5000 to check they all say =O11>N11.

Is this normal or do I need to set more paraneters...?

 

[MikeyZ]

Thnx.
Works.
Consider the Thread Closed...