I Can make conditional formatting for individual cell for example D8 when it is zero make red Pattern and white font.
But on same condition (D8=0) I like to make all column D with red Pattern Background.
How is that possible?
See attached example
Thanks in advance