Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 05, 04:02 PM
MINAL ZUNKE
 
Posts: n/a
Default cell color index comparison

hi
Experts

I am working on excel sheet to compare the cell color index of 5 cell.
say CELL A, CELL B ,CELL C, CELL D, CELL E.

I have used cf to format the color of all cells. If CF condition evaluates
to be true then colour of cell A and
either CELL B or CELL C and
either CELL D or CELL E

colour becomes same.

what I am trying to do is to compare the cell colour index.
If colour index of CELL A
matches with colour index of either CELL B OR CELL C
and with colour index of either CELL D OR CELL E

then the colour index of CELL G should be same as the colour index of all
the compared cells.

Any easy solution greatly appreciated
Thnx




  #2   Report Post  
Old June 30th 05, 07:11 AM
Max
 
Posts: n/a
Default

.. what I am trying to do is to compare the cell colour index ...
... Any easy solution ..


Think a simple way to drive it out in col G would be to check the underlying
CF conditions set in the precedent cols A to E

For example, suppose you have conditionally formatted cols A to E to trigger
the cell fill color (say, green) with the CF formulas:

=A1=1
=B1=1
=C1=1
=D1=1
=E1=1

Then for col G, if we set the CF formula as:
=AND(A1=1,OR(B1=1,C1=1),OR(D1=1,E1=1))
and set the fill color to green as well ...

If col G's CF formula above (set to check that the underlying conditions in
cols A to E are satisfied in the desired manner), evaluates to TRUE, then
this will trigger the same cell fill color (green) in col G
(which will achieve the effect that you're after)

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"MINAL ZUNKE" wrote in message
...
hi
Experts

I am working on excel sheet to compare the cell color index of 5 cell.
say CELL A, CELL B ,CELL C, CELL D, CELL E.

I have used cf to format the color of all cells. If CF condition

evaluates
to be true then colour of cell A and
either CELL B or CELL C and
either CELL D or CELL E

colour becomes same.

what I am trying to do is to compare the cell colour index.
If colour index of CELL A
matches with colour index of either CELL B OR CELL C
and with colour index of either CELL D OR CELL E

then the colour index of CELL G should be same as the colour index of all
the compared cells.

Any easy solution greatly appreciated
Thnx







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
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
How do I copy a function for comparison but keep first cell value. N'wester Excel Worksheet Functions 0 February 22nd 05 04:53 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 10:48 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017