Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Conditional Formatting and Greater than or equal too | Excel Discussion (Misc queries) | |||
Conditional formatting based on an equal value in another workshee | New Users to Excel | |||
Conditional Format a cell that contains a function | Excel Discussion (Misc queries) | |||
Conditional Format =max Function | Excel Discussion (Misc queries) | |||
The conditional format function | Excel Worksheet Functions |