ShoaibAli
Banned - Rules violations
- Joined
- Jan 15, 2020
- Messages
- 121
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Dear Experts,
Using Conditional Formatting but it is just highlighting those cells where Row2 have "Sat","Sun".
I have merged the column for In and Out status but it is just considering Cell I2, Cell W2 to highlight the entire column.
All i want is that if whichever cell has "Sat","Sun" in row2 then entire columns should be highlighted for in and out status.
Using Conditional Formatting but it is just highlighting those cells where Row2 have "Sat","Sun".
I have merged the column for In and Out status but it is just considering Cell I2, Cell W2 to highlight the entire column.
All i want is that if whichever cell has "Sat","Sun" in row2 then entire columns should be highlighted for in and out status.