Forum Discussion
Conditional formatting issues
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 ce...
One thought, Does excel interpret a sequence of rules as conditional "and"? If so, is there a way to make the interpretation "or"?
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
