A B C
DATE 1 Supplier DATE 2
12-Nov BTT 10-Nov
12-Nov BCT 11-Nov
13-Nov BTT 12-Nov
11-Nov BLL 13-Nov
11-Nov BCT 4-Nov
16-Nov BTT 12-Nov

In the above list I need to format DATE1 ( A) when SUPPLIER (B)="BTT" AND
DATE1-DATE2 ( A-C)3 USING CONDITIONAL FORMATTING

Should highlight the 1st & 3rd rows of data

Hi Asoka

1. Select the cell/Range (say A1:C10) so that the active cell is A1. Active
cell will have a white background even after selection. If your selection is
A2:C10 and active cell is in row 2 then the row number mentioned in the
formula should be 2 instead of 1
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=AND($B1="BTT",$A1-$C13)
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

I tried with your sample and only the last row gets highlighted...(not 1 and
3) as only the last row satisfies both conditions

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.


If this post helps click Yes
---------------
Jacob Skaria


"Asoka Walpitagama - Brandix College IT" wrote:

A B C
DATE 1 Supplier DATE 2
12-Nov BTT 10-Nov
12-Nov BCT 11-Nov
13-Nov BTT 12-Nov
11-Nov BLL 13-Nov
11-Nov BCT 4-Nov
16-Nov BTT 12-Nov

In the above list I need to format DATE1 ( A) when SUPPLIER (B)="BTT" AND
DATE1-DATE2 ( A-C)3 USING CONDITIONAL FORMATTING

Should highlight the 1st & 3rd rows of data