THANKS!!!!! This worked and it was much simpler
-----Original Message-----
Will this work:
Highlight column C, select conditional formatting,
choose 'Formula Is' and
enter
=countif(H1,"Legal Fees")=1
This should format the cells in column C if the
corresponding cell in column
H has Legal Fees in it.
"DavidL" wrote:
I have two columns that I want to format with a
background
color when a certain condition is met for one column
(column H).
If the cell value which is a text string in H10 is
LEGAL
FEES, then I want this cell formatted with a background
color (I did this with no problem). When cell H10 has
LEGAL FEES in it and is formatted with a background
color,
I want C10 formatted the same color. I cannot make
that
happen to cell C10.
Is this possible?
thanks,
david
.
|