Hi Joel,

Have the other posts answered your question sufficiently for you to do what
you want? If not then still need more information. For example if U2:Y2 is
the range to turn red and strike through, what cell (or cells) need to be
tested for zero. Need the actual cell addresses and I assume that for the
other rows these addresses will have the same relativity to the U - Y address
as for row 2.

--
Regards,

OssieMac


"Joel" wrote:

Thanks Ossie

The Cell range is U to Y

The table looks like the


2 Electric £79.00
3 Gas £74.00
3 Water £40.00

Lets say I pay my electric bill and that shows 0 I want it to put a
strikethrough the whole row and turn it red.

Then when I pay my gas bill want the same to happen and so on...

Thanks again
--
N/A


"OssieMac" wrote:

Can you post a sample range of cells that is to turn Red plus the cell
address which will be zero when the range turns red etc.

Need to know what the relationship is between the cells to be conditionally
formatted and the cell that contains the value to control it.

--
Regards,

OssieMac


"Joel" wrote:

I have a small offset group of cells on the edge of my main spreadsheet which
details my monthly bills.

When a bill has been paid and reads 0 I want it to turn red and put a
strikethrough that row. Not the entire row just part of the row that shows
that my little table on the edge of my spreadsheet.

Regards and thanks in Advance
--
N/A