More conditional formatting

J

JSeddon

I would like to change the pattern colour of a cell based on what pattern colour another cell is, e.g. if cell b3 is red with no text in, I would like cell a1 to be red also. Does anyone know how to do this?
 
F

Frank Kabel

Hi
not possible without using VBA (to get the color of the
other cell) It wuld be easier if you could use a condition
which is not based on a format
-----Original Message-----
I would like to change the pattern colour of a cell based
Click to expand...
on what pattern colour another cell is, e.g. if cell b3 is
red with no text in, I would like cell a1 to be red also.
Does anyone know how to do this?
 
F

Frank Kabel

Hi
not possible without using VBA (to get the color of the
other cell) It wuld be easier if you could use a condition
which is not based on a format
-----Original Message-----
I would like to change the pattern colour of a cell based
Click to expand...
on what pattern colour another cell is, e.g. if cell b3 is
red with no text in, I would like cell a1 to be red also.
Does anyone know how to do this?
 
D

David McRitchie

Hi Jon,
Adding to Frank's comments.
If Cell B3 was set by conditional formatting
then you might set the C.F. in cell A1 like
Formulas is: =AND(conditionforB3,A1="")
using the conditional formula you used in Cell B3, but watch out
for the fact that you will have to adjust the formula used in B3
to be relative to Cell A1.

more on conditional formatting in
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Since a cells interior color, or font color can be set by
formatting or by conditional formatting you would need to be
more specific. I would really try to keep Conditional Formatting
Formulas to builtin Excel Worksheet Formulas.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

JSeddon said:
I would like to change the pattern colour of a cell based on what pattern colour another cell is, e.g. if cell b3 is red with no
Click to expand...
text in, I would like cell a1 to be red also. Does anyone know how to do this?
 
Top