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)
Add Service Pages & Boost SEO Category: Content Development, Content Writing, Internet Marketing, Keyword Research, Link Building, Marketing, SEO, Web Development, Web Design, Website Optimization Budget: £250 - £750 GBP
Site e Redes para Consultório Category: Article Writing, Content Creation, HTML, Link Building, SEO, Social Media Management, Web Design, WordPress Budget: $250 - $750 USD
SEO-Optimized Blog Post Series Category: Article Rewriting, Article Writing, Blog, Blog Writing, Content Writing, Keyword Research, SEO, SEO Writing Budget: £250 - £750 GBP
Animated Background Replication Category: Adobe Premiere Pro, After Effects, Animation, Graphic Design, Motion Graphics, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: £10 - £50 GBP