1) Is there any way to conditionally format a cell based on the value in another cell?

2) Is there a way to paste the results of a conditional format as a format for another cell?

Danika

On Tue, 20 Sep 2005 16:28:11 -0700, "danika" <(E-Mail Removed)> wrote:

>1) Is there any way to conditionally format a cell based on the value in another cell?

Use the Formula Is: option. e.g. in A1: Format/Conditional Formatting/Formula
Is: =A2>=15

>
>2) Is there a way to paste the results of a conditional format as a format for another cell?

Paste All, Paste Special Formats, and the Format Painter will all copy the
conditional format, also. If you are using a Formula in the conditional
formatting, you need to ensure your absolute/relative references adjust the way
you intend.

--ron

1) Yes, just set the other cell as a cell reference with an operator of
Equal

2) Yes. Use the format painter (the brush icon) to copy it to the other
cell.

--
HTH

Bob Phillips

"danika" <(E-Mail Removed)> wrote in message
news:JYOdnaXFfv2QBq3eRVn-(E-Mail Removed)...
1) Is there any way to conditionally format a cell based on the value in
another cell?

2) Is there a way to paste the results of a conditional format as a format
for another cell?

Danika

Sorry, looks like my second question wasn't clear. I want to paste the results of the conditional format to another cell, not the format itself. For example if the conditional format specifies the background as red for 0 and green for 1, then I want to paste the red and green formats to another group of cells.

>Use the Formula Is: option. e.g. in A1: Format/Conditional Formatting/Formula Is: =A2>=15

Thanks. Works great.

On Wed, 21 Sep 2005 08:41:16 -0700, "danika" <(E-Mail Removed)> wrote:

>Sorry, looks like my second question wasn't clear. I want to paste the results of the conditional format to another cell, not the format itself. For example if the conditional format specifies the background as red for 0 and green for 1, then I want to paste the red and green formats to another group of cells.

That is a matter of using the correct type of reference with regard to your
comparison.

You MUST have a conditional format set for those cells, but it's easy to do
once you get the hang of it.

For example, let us say that you want A1:I1 to be conditionally formatted if
B1>A1, and A2:I2 if B2>A2. In that case, the "format formula" in A1 would be:

Formula Is:

=$B1>$A1

Then when you use the format painter, for example, horizontally, the columns
will remain fixed at A and B. But when you use it vertically, the Rows will
adjust.

All sorts of variations depending on what exactly you want to do.


--ron