2013-02-12

Excel: Coloring a row based on a single cell

Use a formula:

To color the whole row if in column A is the text x

=INDIRECT("A"&ROW())="x"

=INDIREKT("A"&ZEILE())="x"
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)