DashboardNovice
Member
I am unable to upload a sample file because of confidential data. The attached picture shows the formula I am using.
When I copy this formula into a blank cell outside of my conditional formatting table to see what the individual parts of the formula evaluate to, the first part testing if B15 <> "" evaluates to TRUE.
The last part with the VLOOKUP evaluates to N=Y, which evaluates to FALSE, therefore the entire AND( ) evaluates to FALSE.
Because the entire formula evaluates to FALSE, this means the green font should not be applied, but the green font is being applied in my CF table.
Why is the green being applied as if the entire formula evaluates to TRUE?
![Chandoo.org - Conditional Formatting.PNG Chandoo.org - Conditional Formatting.PNG](https://chandoo.org/forum/data/attachments/89/89695-e26577a071bb6ad4bb509bbba4c6ecdf.jpg)
When I copy this formula into a blank cell outside of my conditional formatting table to see what the individual parts of the formula evaluate to, the first part testing if B15 <> "" evaluates to TRUE.
The last part with the VLOOKUP evaluates to N=Y, which evaluates to FALSE, therefore the entire AND( ) evaluates to FALSE.
Because the entire formula evaluates to FALSE, this means the green font should not be applied, but the green font is being applied in my CF table.
Why is the green being applied as if the entire formula evaluates to TRUE?
![Chandoo.org - Conditional Formatting.PNG Chandoo.org - Conditional Formatting.PNG](https://chandoo.org/forum/data/attachments/89/89695-e26577a071bb6ad4bb509bbba4c6ecdf.jpg)