Good day,
I am trying to build a spreadsheet that tracks my aircrew's flight currencies.
On the General tab the last column (N) I am trying to somehow indicate to my personnel that if anything is red in columns B-M then column N will also be red (or some other indicator).
If all the other columns are uncolored then the box to the right in column N is green (or some other indicator).
I have attached my spreadsheet and any help with this problem would be appreciated.
Last edited by mistrornge; 03-01-2010 at 07:37 PM.
Unfortunately, everything is red. You did not provide any sample data that would indicate when a cell would be red or not.
---
Ben Van Johnson
I put in a sample line on this attachment. Columns I, J and K are now red. So what I am hoping to do is because columns I, J and K are red it will cause column N to change. Perhaps to turn red and say "Under Trained"
New on the forums so if I can do anything else to help please comment!
Tru\y this formula in column N and apply conditional formatting based on its results:
Code:=IF(AND((AND(NOT(ISBLANK(I4)),I4<=TODAY())),(AND(NOT(ISBLANK(E4)),E4<=TODAY())),AND(A4>"",ISBLANK(K4),OR(K4>TODAY()+1,K4<TODAY()+179))),"Training Current","Under Trained")
---
Ben Van Johnson
Thank you for your help Proton. Sorry I have been slow to reply but I have been flying missions into Haiti.
I have attached a copy of a file that should show as "Training Current" but is still showing as "Under Trained." That is quite the string. Thank as I am sure that took sometime to write.
If you look at the attachement the member "Morris" should show as Training Current with the entire row being white.
I think the revisions will work.
---
Ben Van Johnson
Wow. Thank you proton
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks