VinceF
Board Regular
- Joined
- Sep 22, 2007
- Messages
- 172
- Office Version
- 2016
- Platform
- Windows
Another one for the experts. I'm trying to apply conditional formatting using the format painter but for whatever reason it doesn't seem to be Appling the condition as it should.
I have 9 columns Z5 thru AH5 and 39 rows J12 thru J51
The formula that I'm using is =AND($B$7="Half","Half Stroke Skins"!,$Z5=1)) when I drag this across with FP it doesn't hold the formatting correctly. I then manually corrected each cell in the row 5 to this...=AND($B$7="Half","Half Stoke Skins"!,Z$5=1)) and tried dragging it down, same problem.
I hope that I've explained this adequately and thank you for your assistance.
VinceF
Win 10
Office 2016
I have 9 columns Z5 thru AH5 and 39 rows J12 thru J51
The formula that I'm using is =AND($B$7="Half","Half Stroke Skins"!,$Z5=1)) when I drag this across with FP it doesn't hold the formatting correctly. I then manually corrected each cell in the row 5 to this...=AND($B$7="Half","Half Stoke Skins"!,Z$5=1)) and tried dragging it down, same problem.
I hope that I've explained this adequately and thank you for your assistance.
VinceF
Win 10
Office 2016