Conditional Formatting Questions

D

danika

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
 
R

Ron Rosenfeld

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

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?
Click to expand...

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
 
B

Bob Phillips

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

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
 
D

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

danika

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

Thanks. Works great.
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
Top