Conditional Formatting issue

[Daibear]

Hi,

First post and this will be a simple one for you to advise me on.

Trying my first conditional formatting set up which is causing me an issue.

125 rows from C6:P130. I want each row to be highlighted if O has value of 16.

I thought this is right but not working. =$O$6 ="16"

Help will be much appreciated.

 

[Fluff]

Hi & welcome to MrExcel.
Try it like

=$O6=16

 

[Daibear]

Thank you. Glad I didn't spend more than 10 mins on it.

Look forward to picking your brains again in future.

 

[Fluff]

You're welcome & thanks for the feedback.