Color a row once a "x" is entered
I need a formula that will color a row A5:O5 once "X" is entered in N5.
Thank you in advance for your help!!! |
Color a row once a "x" is entered
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!!! |
All times are GMT +1. The time now is 02:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com