LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default attempting to format a color pattern in tab 3, based tab 2 and tab

I have many cells of data on tab 1 (Actual data), it is replicated on tab 2
but with a different data set (Budget data), and tab 3 is the difference
between those first 2 tabs and I want each of the cells on tab 3 to evaluate
against tabs 1 and 2. In tab 3, if the same cell, say c3, in tab 1 is less
than ABS of 1, AND the same cell in tab 2 is greater than ABS of 1, then the
same cell, say C3, on tab 3 I want a color pattern of Blue, else no color
pattern.

Thanks for your help.
 
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
Format row color based on individual cell Beawesum Excel Discussion (Misc queries) 3 August 15th 08 08:09 PM
Attempting to compare and deduct values based on date codes Lynn Excel Discussion (Misc queries) 3 June 2nd 08 02:19 PM
Recognition of color pattern in cells to use in Conditional format Quandary 11 - 3 - 07[_2_] Excel Discussion (Misc queries) 1 May 17th 07 08:07 AM
Cond. format text color based on another's text color manxman Excel Discussion (Misc queries) 3 August 31st 06 06:27 PM
How do I change color pattern based upon a formula within a cell? aemuk Excel Worksheet Functions 1 June 16th 06 11:18 PM


All times are GMT +1. The time now is 03:12 PM.

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

About Us

"It's about Microsoft Excel"