HPNPilot1200
En-Route
Hi Guys,
I'm creating a weight and balance spreadsheet in MS Excel based off the C172S, which is the make/model aircraft I fly.
If the Max Takeoff/Landing Weight exceeds 2550 lbs., I would like Excel to change the color of the cell to red, and if it is at/below this number, leave the cell yellow...but I haven't been able to find a function to do so.
In the interim, I just entered the following IF function:
Does anyone know of an MS Excel function that will change color of a cell based on a particular value?
Thanks,
Jason
I'm creating a weight and balance spreadsheet in MS Excel based off the C172S, which is the make/model aircraft I fly.
If the Max Takeoff/Landing Weight exceeds 2550 lbs., I would like Excel to change the color of the cell to red, and if it is at/below this number, leave the cell yellow...but I haven't been able to find a function to do so.
In the interim, I just entered the following IF function:
Code:
=IF(B8+B9<2551,"IN LIMITS","NOT IN LIMITS")
Thanks,
Jason