|Quoting AeroWesty (Reply 1):|
It's called "Conditional Formatting"
|Quoting AeroWesty (Reply 3):|
Right, you have to apply the conditional formatting to cell E6, that would be linked to B9 to display a result. Have you used formulas before?
|Quoting Yhmfan (Reply 5):|
If anyone knows the answer, I will be a happy man!!
|Quoting FutureUApilot (Reply 7):|
Where do we enter in the different messages we want displayed?
|Quoting Yhmfan (Reply 8):|
=IF(D6<2300,"Have a Good Flight!","")
|Quoting FutureUApilot (Reply 12):|
HEY! It now will say "Have a good fight if that landing and takeoff weight is below 2300, but if it is above it says FALSE
|Quoting Yhmfan (Reply 13):|
I suspect you missed the second blank ""
|Quoting FutureUApilot (Reply 14):|
but can we make it so the "Have a good flight" will be green and the "Exceeds Max Takeoff Weight" will be red?
|Quoting FutureUApilot (Reply 20):|
=IF(C24<47 and C24>355 and D24<2400