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...?
=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...?