Hi All,

Is it possible to conditionally format the fill color for an entire
row based on a cell reference?

For instance,

Columns 1,2,and 3 are text but column 4 is a number. I'd like to fill
the whole row blue if the number in that row equals 100.

Then I think I can use the painter to copy the formatting to the rest
of the sheet.

Any ideas would be great.

Thanks,

Trevor