View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kurashi Kurashi is offline
external usenet poster
 
Posts: 1
Default 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