A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to use 2 conditions in conditional formatting



 
 
Thread Tools Display Modes
  #1  
Old November 12th, 2009, 07:24 AM posted to microsoft.public.excel.misc
Asoka Walpitagama - Brandix College IT
external usenet poster
 
Posts: 15
Default How to use 2 conditions in conditional formatting

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
  #2  
Old November 12th, 2009, 07:41 AM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default How to use 2 conditions in conditional formatting

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.