Same conditions multiple cells

  peug417 15:37 07 Sep 2003

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.


  [DELETED] 16:05 07 Sep 2003

take the $ sign out of the source cell(A4 instead of A$4$).


  [DELETED] 16:09 07 Sep 2003

Forgot to say .. and then copy it down.

Just looking at your second problem.


  [DELETED] 17:09 07 Sep 2003

Megatyte is correct.

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.

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

Illustrator Amy Grimes on how setting up her own eco-brand led to success with clients too

MacBook Pro keyboard issues and other problems

Test : l’enceinte connectée HomePod d’Apple