Conditional formating colour

[#1]

Hi,

I have a really strange problem.

I have text boxes with formulas in showing numbers and a variance box to show the difference between the two. I have used a formula to show when one is greater than the other show green otherwise red. It works but then as you start filtering for specialities etc it doesnt work, and its showing red when it should show green etc - but the formula appears correct and it sometimes works!!

Is there something i am missing?

[Anonymous]

Can you please share your document to take a look?

[Clever_Anjos]

Please attach a sample of your app to look it

[#4]

Sorry i dont know how to attach a document from our server. I have taken some screen shots though to show you ...? For example look at the inpatient waiting list variance - works in the first one. then i filter for ENT and its still green yet there were more in's than outs...?

[Anonymous]

When you are answering, there's an "Use advanced editor" link on the right top corner of the gray edit section, once you click there, on the right bottom corner there's the "attach" option.