On Jun 25, 7:04 pm, Bob wrote:
I have been provided with a workbook where alternate rows are highlighted in
a colour that makes the text difficult to read. I would like to change all
the cells with this colour to a lighter colour. Is this possible in an easy
manner?

Conditional Formatting will override the applied fill.
If the dark rows are the odd numbered rows then use Formula Is...

=MOD(ROW(1:1),2)<0

if it's the even numbered rows then use Formula Is...

=MOD(ROW(1:1),2)=0

and in either case apply a lighter coloured fill with the conditional
formatting.

Ken Johnson