|
|
|
|
#1
02-21-2019, 02:14 PM
|
|||
|
|||
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. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional format for times
|
LeClef | Excel | 2 | 07-14-2018 11:07 AM |
| I need help creating a conditional format | tonydoneese | Excel | 5 | 05-28-2017 10:42 AM |
| How does this Conditional Format work? | Gary Drumm | Excel | 7 | 04-16-2014 12:01 PM |
|
Applying a conditional format to multiple rows
|
secoo140 | Excel | 1 | 10-12-2013 07:19 PM |
| Table with Conditional Format to Word | billyV | Excel | 9 | 06-07-2013 08:26 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode