Remember Me?

#1
June 29th 05, 04:02 PM
 MINAL ZUNKE Posts: n/a
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
June 30th 05, 07:11 AM
 Max Posts: n/a

.. 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)

--
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post alani New Users to Excel 3 June 29th 05 03:50 PM Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM N'wester Excel Worksheet Functions 0 February 22nd 05 03:53 AM [email protected] New Users to Excel 2 January 6th 05 07:18 AM KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM

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

The comments are property of their posters.