Conditional formatting Excel

  • Thread starter Thread starter Per Magnus L?vold
  • Start date Start date
P

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
 
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
 
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)
 
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
 
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)
 
Back
Top