Thread: Conditional format with multiple ANDs
View Single Post
 
Old 02-21-2019, 02:14 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
In the sample workbook you attached, select I2
from the Formulas ribbon, in the Formula Auditing section, click Evaluate Formula.
Clicking the Evaluate button, Excel will evaluate the underlined portion of the formula
and you will see one step at a time how Excel works its way through the formula.
The conditional formatting is looking for a true result to apply formatting.
Reply With Quote