Hi,

"Conditional formatting: Considering the fourth option"
http://office.microsoft.com/en-us/ex...CL100570551033

Challa Prabhu

" wrote:

I want to copy conditional format of a perticular cell to the another
cell with its own new reference formula. For example,

If Cell Value of F7 is equal to T7 then cell colour should be Green
&
If cell value of F8 is equal to T8 then again cell colour should be
Green and carry on....

When I am copying the Conditional Format of Cell F7 to F8 in all
conventioanl methods (i.e.Format Paiter or Paste Special....) it is
copying following value in the condition area.

Cell Value of F8 is equal to T7 then cell colour is Green. Hence by
using conventional methods of copying Conditional Formatting,
Condition Formula with respect to the Formatted Cell is not changing.

Please help me out for this issue...

Thanks