make all cells in same row match cell formatted with fill color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zjopa - 21 May 2008 02:04 GMT

If I conditionally formated cells in worksheet that contain specific text to
have a fill color red, how can I get the rest of the cells in the same
row/rows (for the entire worksheet) to match that cell fill color?

Reply to this Message

Dave Peterson - 21 May 2008 03:07 GMT

Use conditional formatting on those cells, too.

But base the condition on the cell that's important -- it doesn't have to be the
cell that changes format.

For instance:

Select A1:x99
With A1 the active cell
Format|conditional formatting
Formula is:
=countif($a1,"*red*")>0
And give it a nice format.

The formula will adjust for each row, but always look at the cell in column A.
If it contains Red, then A:X of that row will get the same format.

> If I conditionally formated cells in worksheet that contain specific text to
> have a fill color red, how can I get the rest of the cells in the same
> row/rows (for the entire worksheet) to match that cell fill color?

Signature

Dave Peterson

Reply to this Message

zjopa - 21 May 2008 04:26 GMT

Thank you so very much, I will try that now. Worksheet is call history for
Call Center I manage and trying to find/figure out hold times of calls not
connected and length of calls connected. Still need to find correct way
current log lists total time as 5,653 min 23 secs (in text I think) to total
converted to hh:mm:ss. I greatly appreciate your help. Thank you very much.
John

> Use conditional formatting on those cells, too.
>
[quoted text clipped - 16 lines]
> > have a fill color red, how can I get the rest of the cells in the same
> > row/rows (for the entire worksheet) to match that cell fill color?

Reply to this Message