Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2017, 11:34 PM
Iraj Iraj is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2007
Novice
How to fill a cell at row and column intersection with conditional Formatting
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Angry How to fill a cell at row and column intersection with conditional Formatting

Hello Pros;

I have a distance calculator sheet with lots of rows and columns of numbers, I used CF to find the distance between two location by CF of specific row with column intersection. I am looking to fill merely the intersection cell.

Can you help how to fill color just intersection cell with CF?



Appreciate in advance.
Cheers.
Iraj
Reply With Quote
  #2  
Old 12-01-2017, 12:38 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,418
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

As you can imagine this is a well-known problem easily found on the Net https://www.youtube.com/watch?v=nvOr2wLj2MU&gl=BE
Reply With Quote
  #3  
Old 12-01-2017, 04:55 AM
Iraj Iraj is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2007
Novice
How to fill a cell at row and column intersection with conditional Formatting
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Default

I have done this myself, if you would have read my explanation properly, I do not want whole row and column be filled, instead just one cell which is at intersection change the color.
Reply With Quote
  #4  
Old 12-01-2017, 05:39 AM
NBVC's Avatar
NBVC NBVC is offline How to fill a cell at row and column intersection with conditional Formatting Windows 10 How to fill a cell at row and column intersection with conditional Formatting Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enough
Default

Can you show your sample workbook and what you are looking for?
Reply With Quote
  #5  
Old 12-01-2017, 06:34 PM
Iraj Iraj is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2007
Novice
How to fill a cell at row and column intersection with conditional Formatting
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Default

CITY Calgary Charlottetown Edmonton Fredericton Halifax Moncton Montreal Ottawa Quebec City Regina St. John's Saskatoon Toronto Vancouver Victoria Whitehorse Winnipeg
Calgary AB 4925 300 4575 4975 4750 3750 3550 4025 775 6350 625 3450 1050 1175 2400 1350
Charlottetown 4925 PE 4975 350 275 175 1200 1400 950 4175 1450 4450 1750 6000 6100 7050 3600
Edmonton 300 4975 AB 4625 5000 4800 3775 3550 4050 800 6375 525 3450 1250 1350 2100 1350
Fredericton 4575 350 4625 NB 450 175 850 1050 625 3825 1750 4100 1400 5650 5750 6700 3250 From To Km
Halifax 4975 275 5000 450 NS 275 1250 1450 1000 4225 1500 4500 1800 6050 6150 7100 3560 Charlottetown Charlottetown PE
Moncton 4750 175 4800 175 275 NB 1025 1225 800 4000 1575 4275 1575 5825 5925 6875 3425 Column # Row #
Montreal 3750 1200 3775 850 1250 1025 QC 200 275 2975 2600 3250 550 4800 4900 5850 2400 3 3
Ottawa 3550 1400 3550 1050 1450 1225 200 ON 475 2800 2800 3050 450 4600 4700 5675 2225
Quebec City 4025 950 4050 625 1000 800 275 475 QC 3250 2375 3500 800 5075 5175 6125 2675
Regina 775 4175 800 3825 4225 4000 2975 2800 3250 SK 5600 250 2675 1825 1925 875 575
St. John's 6350 1450 6375 1750 1500 1575 2600 2800 2375 5600 NL 5850 3150 7675 7775 8550 5025
Saskatoon 625 4450 525 4100 4500 4275 3250 3050 3500 250 5850 SK 2925 1675 1800 2625 825
Toronto 3450 1750 3450 1400 1800 1575 550 450 800 2675 3150 2925 ON 4500 4600 5525 2100
Vancouver 1050 6000 1250 5650 6050 5825 4800 4600 5075 1825 7675 1675 4500 BC 100 2700 2225
Victoria 1175 6100 1350 5750 6150 5925 4900 4700 5175 1925 7775 1800 4600 100 BC 2800 2325
Whitehorse 2400 7050 2100 6700 7100 6875 5850 5675 6125 2875 8550 2625 5525 2700 2800 YT 3525
Winnipeg 1350 3600 1350 3250 3650 3425 2400 2225 2675 575 5025 825 2100 2225 2325 3525 MB
Reply With Quote
  #6  
Old 12-01-2017, 06:50 PM
Iraj Iraj is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2007
Novice
How to fill a cell at row and column intersection with conditional Formatting
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Default

hi,

Here I attched a copy of my distance calculator, just change the name in drop down list, automatically the relevant row and column will fill green with CF. But I would like to have just the intersection cell highlighted with color.

Cheers,
Iraj.
Attached Files
File Type: xlsx Cptex Distance Calculator with CF.xlsx (12.2 KB, 3 views)
Reply With Quote
  #7  
Old 12-02-2017, 01:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,418
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Quote:
Originally Posted by Iraj View Post
I have done this myself, if you would have read my explanation properly, I do not want whole row and column be filled, instead just one cell which is at intersection change the color.
As a mater of fact I did read your post properly, and candidly thought that you would take the time to adapt the proposed solution removing the col and rge CF.
Did you give it a try?
Reply With Quote
  #8  
Old 12-02-2017, 03:46 AM
Iraj Iraj is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2007
Novice
How to fill a cell at row and column intersection with conditional Formatting
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Default

Hi ,

I did not get your point, can you please give me the little bit of details. If I remove the Col how does that work then.
Reply With Quote
  #9  
Old 12-02-2017, 04:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,418
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Take a minute to look at the video and only use the last conditional formatting ( orange)
As it is well explained, you will learn how to do it for the future.
Reply With Quote
  #10  
Old 12-02-2017, 08:00 AM
Iraj Iraj is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2007
Novice
How to fill a cell at row and column intersection with conditional Formatting
 
Join Date: Sep 2013
Posts: 18
Iraj is on a distinguished road
Thumbs down

I need no utube like this. You do not get what I asked. I just want one cell which is at the intersection of row and column to change color not entire row and entire column. Hope you pay little attention to the question.
Reply With Quote
  #11  
Old 12-02-2017, 09:54 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to fill a cell at row and column intersection with conditional Formatting Windows 7 64bit How to fill a cell at row and column intersection with conditional Formatting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,418
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Again, watch the video but skip the part about the range and column. The intersection highlighting is described and does not depend on formatting the row or the column.
But perhaps you would like someone else to do everything for you?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Fill Patterns Conditional Formatting aramaglia Excel Programming 1 05-15-2017 06:35 AM
Conditional Formatting a column Washbue1 Excel 3 01-27-2017 01:11 PM
How to fill a cell at row and column intersection with conditional Formatting Question re: Conditional formatting (cell occurs after another cell) Saywarder Excel 1 04-20-2015 11:29 AM
Conditional Cell Formatting: Alternating Cell Checks corbott Excel 4 12-16-2014 01:51 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:46 AM.


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