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?

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.

zjopa wrote:

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?

--

Dave Peterson

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



"Dave Peterson" wrote:

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.

zjopa wrote:

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?

--

Dave Peterson