bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by Lavanya Pandian

Hi All,

Is there a way to compare contents between two sheets, and use conditional
formatting to highlight the difference without using Macro? I am looking at
data of A10:T140

conditional formatting doesnt support to compare the values in other sheet.

So you can copy the contents of other sheet (sheet2) somewhere beside sheet1 and use conditional formatting to compare.

all the best

__________________
Thanks
Bala

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Compare & highlight changes between two worksheets?	Katie	Excel Worksheet Functions	3	March 7th 09 02:51 PM
I want to compare old and new datasheets and highlight changes	Barry	Excel Worksheet Functions	4	February 6th 08 06:33 PM
Compare and Highlight Rows	Lisab	New Users to Excel	12	December 6th 07 03:26 PM
Compare two Cells and highlight third cell	Timmy	Excel Worksheet Functions	3	November 21st 07 08:38 PM
Compare lists and highlight matches	srain001	Excel Discussion (Misc queries)	2	March 1st 07 02:01 PM

All times are GMT +1. The time now is 08:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us