formula needed for conditional formatting

[veena]

I need a formula that will highlight the cells in column B if the difference
between Column A and B is above 10% and also if the difference in negative
and its as high as 10% i want it to highlight. Can someone please help me
with this. thank you in advance.
A B
GM% CURR GM%
68.5 63.6
48.5 60.5
36.8 43.2
75.4 40.6

 

[Mike H]

Select Column B starting in B2 down then

Format|Conditional format
Formula is
=MAX(A2,B2)>MIN(A2,B2)*1.1

Pick your colour and click OK

Mike

 

[veena]

Thank you! can i ask you where i can learn these tricks.

 

[David Biddulph]

One of the best places to learn these tricks is on this newsgroup.

 

[veena]

yeah this place is really helpful! i have another problem i have 2 sheets
in a workbook and i want sheet 1 column to bring the value from sheet 2
column D. the problem is that Sheet 2 the spaces between each value is 3 and
on sheet 1 the spaces are 5. so i want the formula on sheet 1 after every 6
spaces and i want it to know that on sheet 2 the values are after every 4
spaces. i hope i making sense.
sheet 1 Sheet 2
A D
1 1009655 1009655
2
3
4
5 1009685
6 1009685
7
8
9
10

 

[veena]

i know! i was reading it and i realised i didnt type it properly i just put
the question as a new question maybe if you can check that for me. thanks