Nested functions in conditional formatting formulae

I am trying to format a range of cells as a function of cell value compared
with other cells. My attempts have failed so far. For e.g.:
=OR(ADDRESS(ROW(),COLUMN())=$B$18,ADDRESS(ROW(),COLUMN())=$B$17)
=OR(INDIRECT(CONCATENATE("R",(ROW()+1),"C",COLUMN()),FALSE)=B17)
I do not wish to write VB code.
Thanks in advance for any ideas.

Maybe you could post what you are trying to achive
it's hard to guess what you are trying to do


--

Regards,

Peo Sjoblom


"Joseph" <Joseph@discussions.microsoft.com> wrote in message
news:3331CF9E-E84E-44D0-8186-6F9E19DEE267@microsoft.com...
> I am trying to format a range of cells as a function of cell value
compared
> with other cells. My attempts have failed so far. For e.g.:
> =OR(ADDRESS(ROW(),COLUMN())=$B$18,ADDRESS(ROW(),COLUMN())=$B$17)
> =OR(INDIRECT(CONCATENATE("R",(ROW()+1),"C",COLUMN()),FALSE)=B17)
> I do not wish to write VB code.
> Thanks in advance for any ideas.

The objective is determine, for e.g., the backgraound colour of cells in an
array, as a function of their content. The specific case in this exercise is
the DoReMi musical staff (set of lines).

The content of every cell is compared with a pair of cells, and in the
background colour is modified if the OR() returns a TRUE value.

"Peo Sjoblom" wrote:

> Maybe you could post what you are trying to achive
> it's hard to guess what you are trying to do
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Joseph" <Joseph@discussions.microsoft.com> wrote in message
> news:3331CF9E-E84E-44D0-8186-6F9E19DEE267@microsoft.com...
> > I am trying to format a range of cells as a function of cell value
> compared
> > with other cells. My attempts have failed so far. For e.g.:
> > =OR(ADDRESS(ROW(),COLUMN())=$B$18,ADDRESS(ROW(),COLUMN())=$B$17)
> > =OR(INDIRECT(CONCATENATE("R",(ROW()+1),"C",COLUMN()),FALSE)=B17)
> > I do not wish to write VB code.
> > Thanks in advance for any ideas.
>
>
>

Found a solution:
=OR(CELL("contents",INDIRECT(ADDRESS(ROW(),3)))=$B$17,CELL("contents",INDIRECT(ADDRESS(ROW(),3)))=$B$18)

Where $B$17 and $B$18 contain the values Do and Ti. The funtion
CELL("contents",INDIRECT(ADDRESS(ROW(),3))) resolves to the value in the 3rd
column on the current row, which has the modified solfege resulting from the
musical key. if that value equals Do or Ti, the background colour of the cell
is modified, thus giving the student a visual image of the note distances.

Regards,
Joseph

"Peo Sjoblom" wrote:

> Maybe you could post what you are trying to achive
> it's hard to guess what you are trying to do
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Joseph" <Joseph@discussions.microsoft.com> wrote in message
> news:3331CF9E-E84E-44D0-8186-6F9E19DEE267@microsoft.com...
> > I am trying to format a range of cells as a function of cell value
> compared
> > with other cells. My attempts have failed so far. For e.g.:
> > =OR(ADDRESS(ROW(),COLUMN())=$B$18,ADDRESS(ROW(),COLUMN())=$B$17)
> > =OR(INDIRECT(CONCATENATE("R",(ROW()+1),"C",COLUMN()),FALSE)=B17)
> > I do not wish to write VB code.
> > Thanks in advance for any ideas.
>
>
>