Conditional Formatting if certain cell meet certain conditions

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting if certain cell meet certain conditions

FAQ

Thread Tools

Display Modes

11-25-2016, 12:52 AM

xor

Windows 10 Conditional Formatting if certain cell meet certain conditions

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

Select the cell you want to color.
Use the following formula in Conditional Formatting:

=($E$2="NMC")*($E$5="NMC")*($E$6="NMC")

Format as you want.
OK. OK.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum cell by color that are conditional formatting	ijewel	Excel	1	03-16-2016 05:15 AM
Question re: Conditional formatting (cell occurs after another cell)	Saywarder	Excel	1	04-20-2015 11:29 AM
Conditional Cell Formatting: Alternating Cell Checks	corbott	Excel	4	12-16-2014 01:51 PM
Conditional Formatting based on Value of Another Cell	SteveBump	Excel	3	03-07-2014 09:16 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 AM.