Percentage flag

[soulmiester]

Hi all this is my first time here so please be gentle.
I have a basic sales board consisting of reps, days of the week, double sales and single sales, mandates and total. Each mandate can be a single or a double but what i need is a formula that will flag the mandates cell if the total doubles sales breaches 30% of the total mandates sold.
Example.
Steve on monday sells 8 lines, 3 doubles and 2 singles and does this monday to friday. This would give him 15 doubles and 10 singles, giving him 25 total mandates. The ratio from 15 doubles to 25 mandates, this represents 60% doubles sales.
What i need is a formula to insert into a new column that shows that percentage relation and for it to flag if it breaches 30%
I know this is long winded but its the only way i could explain what help i need.
Any and all help and advice would be appreciated.
Thank you.
Lee.

 

[etaf]

https://www.dropbox.com/s/3d64df08lvabiyo/Daily figures report sheet example etaf.xlsx?dl=0

 

[soulmiester]

YOU ARE A GOD....
thank you so so much..... this is exactly what i meant, you are a star..

https://www.dropbox.com/s/3d64df08lvabiyo/Daily figures report sheet example etaf.xlsx?dl=0

 

[etaf]

you are welocme
for those who can't get the download
=IF(S4=0,"",SUM((D4+F4+H4+J4+L4+N4+P4)/2)/S4)
if the total is 0 then leave a blank as no total
otherwise
add up the doubles divide by 2 and divid by the total
gives a %
conditional formatting is as described previously