Microsoft Office Forums - View Single Post - [Solved] Conditional Formatting if certain cell meet certain conditions

Thread: [Solved] Conditional Formatting if certain cell meet certain conditions

View Single Post

Old

11-25-2016, 12:52 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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.

Reply With Quote