IF and Conditional Formatting

		Microsoft Office Forums > Microsoft Excel > Excel
IF and Conditional Formatting - Ver.2003

FAQ

Thread Tools

Display Modes

11-13-2011, 08:05 AM

Catalin.B

Windows Vista IF and Conditional Formatting - Ver.2003

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

You can try something like this:
=IF(LEN(B2)>0;"COMPLETED";IF(MONTH(A2)<=6;"WD";IF( AND(MONTH(A2)>6;MONTH(A2)<12);"??";IF(MONTH(A2)>12 ;"BD";"Result if none of the above conditions is met"))))
then, you can use a conditional formatting formula like:
=$C2="WD"

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM
Conditional Formatting	namedujour	Excel	3	08-25-2011 01:46 PM
help with conditional formatting	Snvlsfoal	Excel	3	07-03-2011 11:55 PM
* Conditional Formatting MS 2010	djreyrey	Excel	3	06-03-2011 01:54 AM
Conditional formatting of cell, Excel 2003	Scaffold	Excel	2	05-01-2010 08:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:18 PM.