Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format row color based on individual cell | Excel Discussion (Misc queries) | |||
Attempting to compare and deduct values based on date codes | Excel Discussion (Misc queries) | |||
Recognition of color pattern in cells to use in Conditional format | Excel Discussion (Misc queries) | |||
Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
How do I change color pattern based upon a formula within a cell? | Excel Worksheet Functions |