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

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" wrote:

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

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

"Mike H" wrote:

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" wrote:

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

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

"veena" wrote in message
...
Thank you! can i ask you where i can learn these tricks.

"Mike H" wrote:

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" wrote:

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

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

"David Biddulph" wrote:

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

"veena" wrote in message
...
Thank you! can i ask you where i can learn these tricks.

"Mike H" wrote:

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" wrote:

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

What you showed in your example wasn't quite what you described in the
words.

Try =IF(MOD(ROW(),6)<1,"",OFFSET(Sheet2!D$1,(ROW()-1)*4/6,0)) and adjust to
suit.
--
David Biddulph

"veena" wrote in message
...

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

"David Biddulph" wrote:

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

"veena" wrote in message
...
Thank you! can i ask you where i can learn these tricks.

"Mike H" wrote:

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" wrote:

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