Hi,

Back again,

To handle this with conditional formatting (which will not affect the
underlying fill color:

First define a range name -
1. Choose Insert, Name, Define
2. and in the Names in workbook box enter myColor (or any name you want)
3. in the Refers to box enter
=GET.CELL(14,INDIRECT("rc",0))
Next apply conditional formatting by selecting the range you want to check
and choosing
4. Format, Conditional Formatting
5. Pick Formula is from the first drop down
6. In the next box enter
=myLocked=TRUE
7. Click Format and pick a color

You will need to clear the conditional formatting to turn it off. You could
put that into a macro.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Tony" wrote:

Can you highlight locked cells in excell, so you can check you have locked
the right ones, and after checking turn the highlight off