Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Conditional Formatting and Greater than or equal too Amanda Excel Discussion (Misc queries) 1 May 29th 08 05:17 PM
Conditional formatting based on an equal value in another workshee Jack New Users to Excel 1 May 19th 08 08:50 AM
Conditional Format a cell that contains a function Matheus Excel Discussion (Misc queries) 1 November 10th 07 06:31 PM
Conditional Format =max Function JR573PUTT Excel Discussion (Misc queries) 11 February 24th 06 11:43 PM
The conditional format function smiley Excel Worksheet Functions 1 November 4th 05 05:07 PM


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"