I'm a bit confused - do you want the colour change to apply only to
the headings or to all cells including the headings? It's just that
you say if the heading contains a certain word and the cell below has
a certain value ...

Also, you could apply the conditional format once and then use the
Format Painter to apply this format elsewhere (to other columns, for
example).

Hope this helps.

Pete


On Mar 22, 11:51 am, Hendrik
wrote:
Hi all,

I want to select all my data (headers and values), then apply a conditional
format:

I have headers in row 1 and values in the underlying rows. When a header has
the words ''back office'' in it and the value in the cell beneath it is
greater then 0.0, then I want the cell to be filled orange.

Going on, if the header shows the word ''break'' and the value in the cell
beneath it is equal to 0.25, I want the cell to be filled yellow.

I want to do the above for a whole range of headings. I can't apply a
conditional format to each collum because it's simply too much work (BIG
file).

I'm not sure if this is possible but I appreciate all input.

Thanks!