Further to my qeurey last night which is now resolved, I am looking to have a number of cells (120) to be exact to have the same conditional formatting. If I copy and paste the cells are only responsive to the source cell. Is there a way of copying the format to other cells which would automatically update, ie d4 would turn blue if d4 contained "VOR" and not if A4 contain VOR.
Also on a similair note some of my cells contain formulae to obtain info from other sheets. eg if e5 of sheet1 contains "john" cell c5 of sheet 6 would contain "john". However if cell c5 is blank I have a drop down list on in c5 of sheet 6 to choose 3 options, one of them being VOR. IF I choose VOR from the list along with its conditional formatting it overwrites the primary formulae, So if the vehicle was driven later with "john" being inserted in e5 of sheet1 C5 of sheet 6 would not update? Any ideas on this one.
I find that Excel sometimes substitutes absolute cell references even when you don't want them. What I do is to set the Conditional Format in one cell, then double check that it is using relative addressing and change if necessary. Then click on the Format Painter button (paintbrush) and select all of the other cells that you want to apply the format to.
Re your second question, if I understand correctly, you are overwriting a formula and I can't see a way around this other than perhaps using an intermediate (perhaps hidden) sheet that always contains the original formula. But I may be missing something.
This thread is now locked and can not be replied to.