I need the following rows 31 -36 & 38-39 I need Check Boxes inserted, centre and aligned
Then I need a rule that turns those check boxes background cells to the following colours based on the following rules
Within Row 10 -13 if the percentages inserted are equal to or above 1, and less than 100 the check boxes back ground in rows 31-36 go Amber / Orange
If the number reaches 100% and the check boxes are not selected it to go RED,
If rows 21 has percentages inserted are equal to or above 1, and less than 100 background cell colours go Amber / Orange, If the percentages are 100, and the check box in row 38-39 are not checked they go red and when checked they go green
The Check boxes cells must be locked down so cannot be editted, moved, deleted but instruction given to be able to remove this by the spreadhseet owner)
Monthly Social Campaign Video Editing Category: After Effects, Facebook Marketing, Instagram Marketing, Video Editing, Video Production, Video Services, Videography, YouTube Video Editing Budget: $30 - $250 AUD
SEO & Google Rank Improvement Category: Google Adwords, Google Analytics, Google Search, Internet Marketing, Link Building, Marketing, Search Engine Marketing (SEM), SEO Budget: $250 - $750 AUD
Lead Generation Specialist Category: Data Entry, Excel, Internet Research, Lead Generation, Leads, Market Research, Product Research, Research, Web Search Budget: $30 - $250 USD
