Excel 2010
I'm making a log for parachute equipment. Essentially I have 3 columns, "CANOPY EXPIRATION" (column C), "HARNESS EXPIRATION" (D), "RISER EXPIRATION" (E). Right now those cells for each chute ID are conditionally formatted to change color based on expiration date. For example, I have it set to
Turn red when cell value is between =TODAY() and (TODAY()-99999) (showing expired equipment)
Turn yellow when cell value is between =TODAY() and (TODAY()-180) (identifing 180 days until expiration)
Turn green when cell value is between =TODAY() and (TODAY()-365) (identifing 365 days until expiration)
After those 3 columns, I have a 4th column titled "FLYABLE?" (column F). This column I want to be a simple Y or N and color coded green when Y, red when N.
I am having trouble setting this column up to read from the other 3 colums though. I want the value of this column to detect if any of the other 3 columns are expired, and then display the applicable Y or N and color code.
I have tried inputting this into cell F4: =IF((C4:E4)<TODAY(),"N","Y")
I thought that would have read from cells C4 through E4, determine if any are less than today, then display "N" if true, "Y" if false. However, I get an error #VALUE!. In evaluating the formula, it underlines the (C4:E4) portion, so I assume that is where it is detecting the error. I'm not sure what's wrong with that though.
Besides that, is it even possible to have a cell change color based on an "=IF" ? Is there an easier way to do this with conditional formatting?
I'm pretty new to this, just learned some basic conditional formatting today while building this spreadsheet.
I have attached the file .xlsx and .xls, but the .xls may not have all the functionality.
Bookmarks