How to use conditional formatting for two criteria?

		Microsoft Office Forums > Microsoft Excel > Excel
How to use conditional formatting for two criteria?

FAQ

Thread Tools

Display Modes

12-06-2017, 09:53 AM

Pecoflyer

Windows 7 64bit How to use conditional formatting for two criteria?

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Basically the CF would be =AND($A1="yes",$A2="-") applied to the cell/range you need to color

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Last edited by Pecoflyer; 12-07-2017 at 01:12 AM.

Tags

conditional formatting, two criteria

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting	chrisoconn	Excel	0	07-05-2017 02:10 AM
Conditional formatting	bbutl027	Excel	15	12-05-2016 08:56 PM
Conditional Formatting	sdfrance	Excel	3	01-06-2015 07:10 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM

Other Forums: Access Forums

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