Conditional Formatting help

[zyosis]

Hi,

I have 3 columns of data, where the business and the ICT dept can allocate a priority score, which is then weighted to give an overall considerate score (Priority).

What I want to do is provide conditional format for the priority column, where the scores given by the business and ict are more than 3 points apart. as this indicator will assess where the business and ict priorities are not aligned (which may be ok, just needs to be explored further).

Priority	Business Priority	ICT Priority
	60%	40%
6.4	8	4
6.8	10	2
5.8	3	10
10	10	10
6.2	9	2
7	7	7
7.6	6	10

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[Latchmaker]

select the cell to highlight
in your example it would be A3
go to conditional formating and select
Use a formula to determine which cells to format
use this formula modify if the reference if the cell you are formatting is not A3
=OR($B3-$C3>3,$C3-$B3>3)

 

[zyosis]

Thanks Latchmaker, that worked superbly!!