Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
conditional formatting to multiple cells | Excel Worksheet Functions | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions |