Sandman1985
New Member
- Joined
- Jun 22, 2022
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
Hi All,
Hope you're well.
Using a formula to conditional format a range and can't for the life of me work out why it isn't working.
I have a value in H9 that is dynamic. I have set the formula to
H9=Sam - taken the absolute reference off the H9 as I want to be able to copy and make the table bigger without continuing to look at the value in H9.
G15:L24 turns red - only G15 is turning red. Not the rest of the specified range.
If I make H9 absolute, it highlights the whole range - but then I can't copy the table over.
Any ideas appreciated
Regards,
Sandman
Hope you're well.
Using a formula to conditional format a range and can't for the life of me work out why it isn't working.
I have a value in H9 that is dynamic. I have set the formula to
H9=Sam - taken the absolute reference off the H9 as I want to be able to copy and make the table bigger without continuing to look at the value in H9.
G15:L24 turns red - only G15 is turning red. Not the rest of the specified range.
If I make H9 absolute, it highlights the whole range - but then I can't copy the table over.
Any ideas appreciated
Regards,
Sandman