Conditional Formatting

[bronek]

Hello,

I am trying to get an entire row's background colour to change in Exce
based on the value of one cell in its column. I can get this to wor
for one cell at a time by using conditional formatting. Is there wa
to get this to work for multiple cells and rows, whether with o
without conditional formatting?

Cheers

Brone

 

[Guest]

Use an absolute reference by placing dollar signs around the cell reference.
i.e. $A$2.