Conditional formatting issues

[Jeff Brown]

I have set up conditional formatting using a formula referencing a cell in a master sheet in the same workbook. If the dependent cell equals the value in the master, it should format the dependent cell with unique font and fill. However, it sometimes works and sometimes does not.

Is there something I am missing here?

[#2]

One thought, Does excel interpret a sequence of rules as conditional "and"? If so, is there a way to make the interpretation "or"?

[#3]

I think I figured it out. Using "Format cells that contain" seems to work better than a formula.

[#4]

Jeff, if you have few conditional formatting rule Excel performs them on by one from top to down. For example, if you have such two rules

all values in the range which are more than 20 will be green, for such sequence

values between 20 and 30 will be green, more than 30 - yellow.

You may also play with Stop If True