conditional format equal function
I am trying to use a conditional format to highlight cells that are pulled
from multiple tabs using the = function. Tab 1 (Dots 1-20), Tab 2 (Squares 21-60) Column A - Item number Column B - Current Names Column E - Previous Names Tab 3 (Results) Column A - All Item numbers 1-60 from both Tabs (Duplicates included and needed) Column B - Names pulled from both Tabs and columns B & E (Have duplicates - must keep) I need to highlight or change font of only Column B current names in Tab 3 1 Joe (Highlight) 1 Bob 1 1 Barb 2 2 Bob (Highlight) 2 Barb 2 3 Barb (Highlight) 3 3 3 |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com