conditional formats

[FROGGER24]

TEST.xls
	B	C	D	E
1	TANK	10
2	INNAGE	3-6-3/4	42.75
3	SIDE	3-5-7/8	41.88
4	REMOTE	3-4-1/4	40.25
5	TANK	25
6	INNAGE	3-6-3/4	42.75
7	SIDE	3-5-7/8	41.88
8	REMOTE	3-4-1/4	40.25
Sheet1

I am trying to shade cells if in column d there is a .5 difference between the 3 cells. I would like to shade the cell that has the tank number in it (column c)

 

[SydneyGeek]

Try this:
Select C1
Format | Conditional Formatting
Change the drop-down from Cell Value Is to Formula Is
Paste this formula into the blank box on the right --

=OR(ABS(D2-D3)>=0.5,ABS(D2-D4)>=0.5,ABS(D3-D4)>=0.5)

Set your format (eg, Pattern could be Red)
OK

To apply down the sheet, copy C1 then select the other values in column C and paste formats

Denis

 

[FROGGER24]

Thanks for the response, your formula worked great.

After some thought is there away to copy the range B1:D4, and pastespecial in the next empty row (in column b) pasting the formulas if cell c4 contains somthing

 

[SydneyGeek]

What you could do is
1. Copy C1
2. Select column C
3. Edit | GoTo | Special | Constants
4. Edit | Paste Special |Formats

Denis