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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Construct table from selected rows 4
Changing row background from external program 0
Tracked changes by multiple people modified to one 0
Value used is wrong data type.. 3
macOS Office365 Word 0
Need formula to STAY 7
Formula to change date when other cells are modifed 9
Match table shading (color) to Visio color/Transparency 1

Top