Change cell color once condition is met

miss_chole, since AlKey is offline now, he did it the same way I did it but he caught the one condition I missed. You go to the "Home" tab and under styles select "conditional formatting", then click on "new rule" and for the months deployed column (F) you select format only cells that contain cell value in the edit rule description and greather than and 6, then the format button and select the fill tab and the color you want then ok, ok and apply.
For the colored blue rows select you select "new rule" to add an additional rule, then "use a formula to determine which cells to format and I used =$C2="available" and copied down all the rows.
Hopefully that's clear.

EDIT: BTW, you can give kudos (* add reputation) to any (or all) who helped you so don't forget to give to AlKey, and if your pblm is solved don't forget to mark the post as such.