Basically In column a are military ranks and column b are the dates they were promoted.
I'm looking to get a conditional format formula to change the color of the row if they were promoted on or before a certain date AND if they are a certain rank.
I have formulas for each individually but nothing that I have tried works to combos them.. I would leave them separate but after about the 3rd rank it messes it up and back to square one.
Here is what I got:
=$a7="PVT"
=$a7="PFC"
=$a7="LCPL"
=if($d7>=datevalue("1/31/2015"),true,false)
=if($d7<=datevalue("1/31/2015"),true,false)
Essentially if they are a LCPL and promoted before Jan 31 color them blue
After color them red
Pfc before yellow
Pfc. After green
PVT just orange
Thanks folks!
Sent from my iPhone using Tapatalk
Bookmarks