=if(and(... formula in conditional formatting dialogue box not working...

Hello there,

I am not sure if this kind of formula can even work in conditional formatting at all?

Please see attached image. It shows the formula I'm trying to use in conditional formatting...

=IF(AND(B18="C Major Scale",D12="C"),1,2)

The arbitrary values of 1 or 2 were placed in the formula to complete it. They do not effect the values of the cell because that is determined by an array. However if the formula condition is met the text colour format is supposed to go red. What I find is that it has gone red whether the condition is met or not.

Any thoughts much appreciated

Chris

=if(and(... formula in conditiona fomatting.JPG

Hi Chris,

Sorry but there is not any image attached.

Please attach you sample with expected result and criteria for getting fast solution.

Rather than an image - lets see a sample excel file

conditional formatting uses TRUE or FALSE result - so you dont need to use the 1 or 2
change
=IF(AND(B18="C Major Scale",D12="C"),1,2)
to
=AND(B18="C Major Scale",D12="C")
IF true - then it will format the cell RED

is that what you want the condition TRUE to turn the cell red
Also you need to be careful the range you select and then the cells you use
whats the range you want to turn red ?

And if B18 and D12 is fixed

so if you select the range B18 to B20 to turn red

when it gets to B20 it will be using the formula
=AND(B20="C Major Scale",D14="C")

if you need any of those cells to stay the same Ie D12 never changes - use a $
=AND(B18="C Major Scale",$D$12="C")

now on row 20 it will use
=AND(B20="C Major Scale",$D$12="C")

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Rather than an image - lets see a sample excel file

see post #3 how to change the rule and also some more questions

Chirs I didn't solve your problem, it was Etaf. BTW Still I am unable to get your desired result.

Regards,
Ankur Shukla