• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting Problem

W

westend9876

Member
I want the cells in B45:AQ73 to be colored black if the following formula is True:
=IF(AND($AT$15<>"Yes",OR($AT$8="X",$AU$8="X",$AT$9="X",$AU$9="X")))

The formula looks like this in the conditional formatting bar:
="IF(AND($AT$15<>""Yes"",OR($AT$8=""X"",$AU$8=""X"",$AT$9=""X"",$AU$9=""X"")))"

However, the cells do not turn black when these conditions are True. What am I doing wrong?
 
Post a sample file with the error you've described - it's a lot easier to see the actual problem in a worksheet than have it described and have to try to re-create it ..
 
Hi ,

This is not a valid Excel formula , since it does not have any of the outputs which are to be returned if the condition being checked for is true or false.

You can use either of the following :

=AND($AT$15<>"Yes",OR($AT$8="X",$AU$8="X",$AT$9="X",$AU$9="X"))

=IF(AND($AT$15<>"Yes",OR($AT$8="X",$AU$8="X",$AT$9="X",$AU$9="X")) , 1 , 0)

Since Excel could not recognize the formula as a valid one , it has converted the whole string into text by enclosing it within quotes ; once this happens , it is no longer going to do what you want done.

Narayan
 
You must log in or register to reply here.
Back
Top