formula needed for conditional formatting
 

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

formula needed for conditional formatting
 

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

formula needed for conditional formatting
 

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

formula needed for conditional formatting
 

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

formula needed for conditional formatting
 

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

formula needed for conditional formatting
 

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

formula needed for conditional formatting
 

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

"David Biddulph" wrote:

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

formula needed for conditional formatting
 

Adjust the formula I gave. You can see how it works.
--
David Biddulph

"veena" wrote in message
...
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

"David Biddulph" wrote:

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