N Nielly Aug 28, 2009 #1 I need a formula that will color a row A5:O5 once "X" is entered in N5. Thank you in advance for your help!!!
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 Aug 28, 2009 #2 Use conditional formatting. Highlight A5:O5, go to formatting/conditional formatting. Choose Formula is and type =$N5="X" then pick the colour you want.
Use conditional formatting. Highlight A5:O5, go to formatting/conditional formatting. Choose Formula is and type =$N5="X" then pick the colour you want.
