Color a row once a "x" is entered

N

Nielly

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

Thank you in advance for your help!!!
 
S

Sam Wilson

Use conditional formatting.

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

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