Dummy Excel
Well-known Member
- Joined
- Sep 21, 2005
- Messages
- 1,004
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
hi all,
hope everyone is safe and well in these conditions.
my question is, i have setup a checklist with multiple columns and rows.
I want to set conditional formatting up for the header row (row1) so that when all the rows (123rows) aren't blank (have a comment or date entered), it changes the header to green.
thanks
Sam
hope everyone is safe and well in these conditions.
my question is, i have setup a checklist with multiple columns and rows.
I want to set conditional formatting up for the header row (row1) so that when all the rows (123rows) aren't blank (have a comment or date entered), it changes the header to green.
thanks
Sam