Hi everyone,
firstly I have recieved some invaluable help recently on this site so thanks to you all.
I have come a cross an issue with conditional formatting in excel 2010 that i'm sure I never had in previosu versions (but i might be worng!)
Basically what I want to do is format multiple rows/columns based on the data in a different column.
e.g (see mock up of sheet below) I would like to change the colour of the rows wher Coulmn D has an entry of o.
A B C D
1 2 x c
2 3 y o
3 5 z c
1 6 q o
Using the conditional format wizard I can mangae to do this for individual columns by adding the formula =D5="o" but when I try to either apply it the range or use the format painter it will only highlight the rows of the firt column where the formula is relevant (in this case A2&A4).
Have I missed a setting? also I have tried adding and removing the $ at various places with no joy.
Any help is gratefully recieved thanks!
firstly I have recieved some invaluable help recently on this site so thanks to you all.
I have come a cross an issue with conditional formatting in excel 2010 that i'm sure I never had in previosu versions (but i might be worng!)
Basically what I want to do is format multiple rows/columns based on the data in a different column.
e.g (see mock up of sheet below) I would like to change the colour of the rows wher Coulmn D has an entry of o.
A B C D
1 2 x c
2 3 y o
3 5 z c
1 6 q o
Using the conditional format wizard I can mangae to do this for individual columns by adding the formula =D5="o" but when I try to either apply it the range or use the format painter it will only highlight the rows of the firt column where the formula is relevant (in this case A2&A4).
Have I missed a setting? also I have tried adding and removing the $ at various places with no joy.
Any help is gratefully recieved thanks!