formula needed for conditional formatting

V

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
 
M

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
 
V

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
 
D

David Biddulph

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.
 
V

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
 
Top