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

Z

zjopa

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?
 
D

Dave Peterson

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.
 
Z

zjopa

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top