Cond Format self deleting

[Ian Betteridge]

Hello All,
I've entered a conditional format.....
=Authorised!$C$6="N"
This works fine until I close and then re-open the file. The CF then seems to have dissappeared. Is this because I'm referencing another worksheet?
Thanks Ian.

 

[VoG]

I think you'll need to create a workbook-wide named range for Authorised!$C$6 then use the name of that named range in the CF formula.

 

[Ian Betteridge]

OK VoG
Thank You