Hi all
I can't see to grasp the concept as to why the conditional format works how it does.
I created a check box and a list of sales individuals (below), column F has a formula showing the max sales. When the check box for "Top Sales" is selected showing "TRUE"
I was hoping that both Column D and E would turn Green.
Within the conditional formatting I have put the following rule in =AND(E4=MAX($E$4:$E$9),$I$3). This doesn't seem to highlight both columns as I would like
What I don't seem to be understanding is that if I put a $ sign in front of the E4 so =AND($E4=MAX($E$4:$E$9),$I$3)
This then seems to highlight both columns and it is this that I can't seem to grasp why, if anyone can shed some light why that would be great.
Many thanks
Arts
I can't see to grasp the concept as to why the conditional format works how it does.
I created a check box and a list of sales individuals (below), column F has a formula showing the max sales. When the check box for "Top Sales" is selected showing "TRUE"
I was hoping that both Column D and E would turn Green.
Within the conditional formatting I have put the following rule in =AND(E4=MAX($E$4:$E$9),$I$3). This doesn't seem to highlight both columns as I would like
What I don't seem to be understanding is that if I put a $ sign in front of the E4 so =AND($E4=MAX($E$4:$E$9),$I$3)
This then seems to highlight both columns and it is this that I can't seem to grasp why, if anyone can shed some light why that would be great.
Many thanks
Arts