conditional formats

seeblue

Board Regular
Joined
Jan 23, 2005
Messages
178
TEST.xls
BCDE
1TANK10
2INNAGE3-6-3/4
3SIDE3-5-7/8
4REMOTE3-4-1/4
5TANK25
6INNAGE3-6-3/4
7SIDE3-5-7/8
8REMOTE3-4-1/4
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

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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 --
Code:
=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
 

seeblue

Board Regular
Joined
Jan 23, 2005
Messages
178
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

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
What you could do is
1. Copy C1
2. Select column C
3. Edit | GoTo | Special | Constants
4. Edit | Paste Special |Formats

Denis
 

Forum statistics

Threads
1,078,098
Messages
5,338,222
Members
399,214
Latest member
vivs2010

Some videos you may like

This Week's Hot Topics

Top