#1
|
|||
|
|||
Formating cells in a Row
I have data in rows A through F. I have an IF formula in Row F to give me a text output if the data in Row B is the highest value or the lowest value. I also have used the conditional formating so those text outputs are a certain color text and fill. My question is this: Is there a way to make rows A-E, where the hightest or lowest value in column F appear, show up in the same formatting? In other words if a row in column F looks like this: HIGH, can I get the other cells in that row to look the same way with a formula or some conditional formatting?
Hope that is clear enough. Mike |
#2
|
|||
|
|||
do you want F to have the highest or lowest value of A-E? Can you type in some example data?
|
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Format line
I can see that what I copied and pasted to my previous response doesn't look like what it does on the spreadsheet. I've attached a screen shot of it to this response.
Mike |
#5
|
|||
|
|||
so you want the MAX & MIN values of column B to appear in a single cell in column F?
|
#6
|
|||
|
|||
Format line
No. I want to know if it's possible with a formula or some conditional formatting to make the row in columns a-d have the format as in row f. The attached is what I want which I did with manually setting the formatting. I want to know if this can be done automatically when the row in column f ends up showing highest or lowest.
Mike |
#7
|
|||
|
|||
you can use conditional formatting on A-D to highlight colors for HIGH & LOW - choose Conditional Formatting then New Rule, choose format only top bottom ranked values. You will have to make 2 rules here one for top & one for bottom & choose top/bottom 1.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
After formating PC | milkmile | Outlook | 2 | 10-12-2010 06:58 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Excel 07 formating 17 cells "Need Formula" | Raner | Excel | 2 | 05-30-2010 02:07 PM |
Removing All Formating | basscarp | Word | 0 | 01-31-2010 05:49 PM |
Formating headline | andrejanubis | Word | 0 | 07-29-2009 05:10 AM |