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!