Forum Discussion
Björn Landelius
Jun 21, 2018Copper Contributor
Conditional Formatting Forumla
Hey! I'd need some help. My goal is that whenever I write E3 in the marked area (I3:U69) I want the cell to become orange when K1 is true. Is there something I'm missing? Thanks
Björn Landelius
Jun 21, 2018Copper Contributor
Hey and thanks for a quick response.
I still don't get it to work, are you sure with your solution?
SergeiBaklan
Jun 21, 2018Diamond Contributor
Yes, I misunderstood your picture, Matt gave correct formula
=(I3="E3")*$K$1