Formatting cell colour based on colour of other cell

[Guest]

If a cell is highlighted because of conditional formatting how do I highlight other cells that contain relative information such as name? Basically what I want to do is "if cell is highlighted, then highlight this cell". Help

 

[JE McGimpsey]

Use the same CF as in the original cell. For instance, if cell A1 has
this CF:

Value is greater than 10

then in J5 enter this CF:

Formula is =A1>10

 

[Don Guillett]

try using the format painter button on your toolbar.
--
Don Guillett
SalesAid Software
(e-mail address removed)

If a cell is highlighted because of conditional formatting how do I

highlight other cells that contain relative information such as name?
Basically what I want to do is "if cell is highlighted, then highlight this
cell". Help