Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-27-2014, 06:20 AM
mbesspiata mbesspiata is offline Formating cells in a Row Windows 7 64bit Formating cells in a Row Office 2010 64bit
Advanced Beginner
Formating cells in a Row
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-27-2014, 07:03 AM
lynchbro lynchbro is offline Formating cells in a Row Windows 8 Formating cells in a Row Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

do you want F to have the highest or lowest value of A-E? Can you type in some example data?
Reply With Quote
  #3  
Old 06-27-2014, 07:22 AM
mbesspiata mbesspiata is offline Formating cells in a Row Windows 7 64bit Formating cells in a Row Office 2010 64bit
Advanced Beginner
Formating cells in a Row
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 06-27-2014, 07:47 AM
mbesspiata mbesspiata is offline Formating cells in a Row Windows 7 64bit Formating cells in a Row Office 2010 64bit
Advanced Beginner
Formating cells in a Row
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default 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
Attached Images
File Type: png Capture.PNG (17.2 KB, 15 views)
Reply With Quote
  #5  
Old 06-27-2014, 07:58 AM
lynchbro lynchbro is offline Formating cells in a Row Windows 8 Formating cells in a Row Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

so you want the MAX & MIN values of column B to appear in a single cell in column F?
Reply With Quote
  #6  
Old 06-27-2014, 08:04 AM
mbesspiata mbesspiata is offline Formating cells in a Row Windows 7 64bit Formating cells in a Row Office 2010 64bit
Advanced Beginner
Formating cells in a Row
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default 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
Attached Images
File Type: png Capture.PNG (18.5 KB, 15 views)
Reply With Quote
  #7  
Old 06-27-2014, 08:12 AM
lynchbro lynchbro is offline Formating cells in a Row Windows 8 Formating cells in a Row Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

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.
Reply With Quote
Reply

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
Formating cells in a Row 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft