Conditional Formatting Set Up for Price Checks Document - URGENT PROJECT
Budget: £10 – £20 GBP
Conditional formatting to be set up to provide a colour key for a price comparison Google Sheet.
Is needed to be set up within the next few hours ASAP!
Column B is the figure to compare all other prices to - we can the competitors price cell (for example, C, G, K, O, S, W, AA, AE, AI, AM, AQ) to highlight the following colours/set rules
Mark COMPETITOR prices in RED if they are CHEAPER than ours. [lower than]
Mark COMPETITOR prices in AMBER if they are THE SAME as ours. [equal to]
If OUR price is the cheapest, and all competitors are more expensive than us, mark OUR price in GREEN. [more than]
***BUDGET IS £30 FLAT RATE***
Is needed to be set up within the next few hours ASAP!
Column B is the figure to compare all other prices to - we can the competitors price cell (for example, C, G, K, O, S, W, AA, AE, AI, AM, AQ) to highlight the following colours/set rules
Mark COMPETITOR prices in RED if they are CHEAPER than ours. [lower than]
Mark COMPETITOR prices in AMBER if they are THE SAME as ours. [equal to]
If OUR price is the cheapest, and all competitors are more expensive than us, mark OUR price in GREEN. [more than]
***BUDGET IS £30 FLAT RATE***