yogi_Conditionally Format Discounted Values That Are Below Bottom Line Price

Google Spreadsheet   Post  #2297

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-22-2017

question by: tayde

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/bPbbqge23pw;context-place=forum/docs

How do I format my sheet with colors for each cell?

I have a discount sheet I created, where each column shows me the individual price of an item when a specific discount percentage is applied. I've added a column that corresponds with the cost of an item that I don't want to go under. How can I format the cells to mark as red if a discount will go under the bottom price of an item? 

(So here I would like the 20% through the 35% of the $200 item to be marked red. I know I can do this through the conditional formatting, but is there some way to format it for the entire sheet instead of formatting each row individually?)

Bottom Line	PRICED AT	10%	15%	20%	25%	30%	35%
$200.00	$250.00	$225.00	$212.50	$200.00	$187.50	$175.00	$162.50
$380.00	$1,100.00	$990.00	$935.00	$880.00	$825.00	$770.00	$715.00

Edited