Forum Discussion
Conditional Formatting - using multiple formulas
I have two formulas. The first is to highlight a cell when a name is present. I.e. if the name "Agnes" is present in column B, highlight a cell i column E. The formula is =($B2="Agnes") This will...
Hi Manne
You may use AND condition
=(Blad3!G$1=MEDIAN(Blad3!G$1;Blad3!$C3;Blad3!$C3+Blad3!$D3-1))*($B2="Agnes")separate rule for each color