Conditional formatting Excel

[Per Magnus L?vold]

Hi,
I was wondering if it is possible to format a range of cells
determined by the condition of a single cell.

I was looking at conditional formatting, but it seems as if you can
only define how the same cell will be formatted.

Example:
if: the single cell a4 contains the value "Sum"
then: format the whole row with double underline

It seems to me as if this is not possible with conditional formatting.
Because you can only define the format of the single cell having the
condition...

Hope someone can help me!

-P

 

[Frank Kabel]

Hi
this is easily possible
Try the following:
- select your cells to be formated. e.g. A4:X4
- goto 'format - Conditional Format'
- choose 'Formula' and enter the formula
=$D4="Sum"
- choose your format

 

[Bob Phillips]

It is simple. Detail what you want to do, and we will show you how.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Per Magnus L?vold]

Thanks!
Found the solution after a while:
Conditional formatting on the whole range of cells did the trick. With
"Formula is" = "=EXACT($E$11;"<Match string>")
followed by the format.

There was one problem, however. If I set one column with conditional
formatting, and another row with another conditional format, then the
format of the row would 'override' the format of the column.
I was hoping the last would append the format to the first format set.

-PML

 

[Bob Phillips]

If you want it appended you need to append it yourself. You can have upto 3
conditions.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)