Formatting cell colour based on colour of other cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 :)
 
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
 
try using the format painter button on your toolbar.
--
Don Guillett
SalesAid Software
(e-mail address removed)
Marta said:
If a cell is highlighted because of conditional formatting how do I
Click to expand...
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 :)
 
Back
Top