Thread: How to fill a cell at row and column intersection with conditional Formatting
View Single Post
 
Old 12-01-2017, 06:50 PM
Iraj Iraj is offline Windows 7 64bit Office 2007
Novice
  
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, 12 views)
Reply With Quote