Use conditional formatting.

Highlight A5:O5, go to formatting/conditional formatting.

Choose Formula is and type =$N5="X" then pick the colour you want.



"Nielly" wrote:

I need a formula that will color a row A5:O5 once "X" is entered in N5.

Thank you in advance for your help!!!