Stclements1
Board Regular
- Joined
- Sep 15, 2018
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
I would like to shade a row of cells if the value in one cell within that row is equal to a given number.
Example ifc2>0 then format cells a2:z2 the formatting would simply be a shading so that it clearly defines that that row is no longer active
so if c2=1 then all cells in that row from a2 to z2 would be shaded over. I beleive this is something I can do in conditional formatting but have tried and not been able to achieve it.
Example ifc2>0 then format cells a2:z2 the formatting would simply be a shading so that it clearly defines that that row is no longer active
so if c2=1 then all cells in that row from a2 to z2 would be shaded over. I beleive this is something I can do in conditional formatting but have tried and not been able to achieve it.