Conditional formatting formula to format cells not equal to a group value

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting formula to format cells not equal to a group value

FAQ

Thread Tools

Display Modes

11-02-2019, 06:15 AM

Marcia

Windows 7 32bit Conditional formatting formula to format cells not equal to a group value

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Thank you! I had been dumbly looking at COUNTIF but resorted to helper columns of VLookup and True/False. I will now delete those in favor of the Index/Match.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to highlight the cells using conditional formatting?	LearnerExcel	Excel	1	01-01-2019 01:43 AM
Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu	AlanBird	Excel	3	11-25-2017 03:11 PM
Conditional Formatting for Cells Containing Formula	Gillian623	Excel	1	12-09-2016 11:03 PM
Conditional Formatting- Only format cells once data is entered	chart3	Excel Programming	1	12-15-2015 11:26 AM
Excel Formula - Conditional replacement of cells	mag	Excel	0	10-27-2012 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:04 AM.