Conditional formatting
 

Hi all'
There are 3 columns A, B and C...Column A and B has numbers and
Column C displays the difference of A and B. Column C displays Yes/No after
comparing the values in Column A and B. I have used Conditional Formatting to
change the color to green when it is Yes and Red when it is No. Now my
problem is when i try and copy the formula to rest of cells in Column C it
copy's the formula but not the Conditional Formatting. Is there a way to copy
the conditional formatting.

Conditional formatting
 

Mir

Either use the Formatting Paintbrush to copy the formatting or Paste
SpecialFormats


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 10:48:02 -0800, "Mir Khan"
wrote:

Hi all'
There are 3 columns A, B and C...Column A and B has numbers and
Column C displays the difference of A and B. Column C displays Yes/No after
comparing the values in Column A and B. I have used Conditional Formatting to
change the color to green when it is Yes and Red when it is No. Now my
problem is when i try and copy the formula to rest of cells in Column C it
copy's the formula but not the Conditional Formatting. Is there a way to copy
the conditional formatting.

Conditional formatting
 

No it does work for the formula but not for conditional formatting...I have
tried doing that...

"Gord Dibben" wrote:

Mir

Either use the Formatting Paintbrush to copy the formatting or Paste
SpecialFormats


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 10:48:02 -0800, "Mir Khan"
wrote:

Hi all'
There are 3 columns A, B and C...Column A and B has numbers and
Column C displays the difference of A and B. Column C displays Yes/No after
comparing the values in Column A and B. I have used Conditional Formatting to
change the color to green when it is Yes and Red when it is No. Now my
problem is when i try and copy the formula to rest of cells in Column C it
copy's the formula but not the Conditional Formatting. Is there a way to copy
the conditional formatting.

Conditional formatting
 

The formatting Paintbrush won't copy formulas but will copy formats so don't
know why "it does not work" for you..

Try this instead.......

Select cells C1:C50 and FormatCFCondition 1Formula is:

=$C1="yes" Format to green

Condition 2

=$C1="no" Format to red

OK your way out.

Now copy the formulas down C



Gord

On Fri, 23 Dec 2005 12:21:02 -0800, "Mir Khan"
wrote:

No it does work for the formula but not for conditional formatting...I have
tried doing that...

"Gord Dibben" wrote:

Mir

Either use the Formatting Paintbrush to copy the formatting or Paste
SpecialFormats


Gord Dibben Excel MVP

On Fri, 23 Dec 2005 10:48:02 -0800, "Mir Khan"
wrote:

Hi all'
There are 3 columns A, B and C...Column A and B has numbers and
Column C displays the difference of A and B. Column C displays Yes/No after
comparing the values in Column A and B. I have used Conditional Formatting to
change the color to green when it is Yes and Red when it is No. Now my
problem is when i try and copy the formula to rest of cells in Column C it
copy's the formula but not the Conditional Formatting. Is there a way to copy
the conditional formatting.