Hello everybody,
I currently have the following list:

I want to create a formula (probably through conditional formatting i'd imagine), that basically says:
If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red background.
As you can see from my list, I currently have a list of data which is pulled from a hidden sheet in the background for cell rows A, B, C & D. However, while these update automatically (and very nicely so too!), the red row with a red background filling does unfortunately not.
Can anybody help me in solving this issue? I would greatly appreciate it!
Thank you so much everybody !
Best regards,
David
I currently have the following list:
I want to create a formula (probably through conditional formatting i'd imagine), that basically says:
If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red background.
As you can see from my list, I currently have a list of data which is pulled from a hidden sheet in the background for cell rows A, B, C & D. However, while these update automatically (and very nicely so too!), the red row with a red background filling does unfortunately not.
Can anybody help me in solving this issue? I would greatly appreciate it!

Thank you so much everybody !
Best regards,
David