Conditional Formatting Not Working on Cells with Formulas

[ejackson37]

Hi Everyone,

I want to colour the row Green if C9 returns True & D9 returns Approved. Both C&D have formulas to return results.

C formula is: =C9=B9
D formula is: =IF(V9="Yes","Approved","Rejected")

My conditional formatting formula is not colouring the cells as desired.

Can anyone help please?

 

[Fluff]

You need to remove the quotes from the word TRUE

 

[Joe4]

Or just removed that part altogether, since it is already returning a Boolean value, i.e.

=AND($C9,$D9="Approved")

 

[ejackson37]

Thank you it has resolved the issue

 

[Fluff]

Glad we could help & thanks for the feedback.