Here is what my spreadsheet looks like.
DATE TTLPEND INVENTORY percent4/17/2014 12,975 61,383 21.1%4/24/2014 13,599 62,084 21.9%5/1/2014 14,773 62,468 23.6%5/8/2014 14,899 62,360 23.9%5/15/2014 15,194 62,273 24.4%HIGHEST TTL PEND5/22/2014 13,382 60,350 22.2%5/29/2014 13,287 60,187 22.1%6/5/2014 12,927 60,094 21.5%LOWEST TTL PEND6/12/2014 13,302 61,068 21.8%6/19/2014 14,410 62,547 23.0%6/26/2014 14,725 63,554 23.2%
My IF formula is in column F (E has some other data in it) to give me the text you see above using MAX and MIN for the data in column B. What I want to know is if there is a way to make the whole line match the formatting on the text in row F where the the highest and lowest show up.
Mike
|