I have a spreadsheet where I am using conditional formatting with IF and VLOOKUP, however I cannot combine the two.
In Column B I currently have VLOOKUP of =VLOOKUP(Y:Y,Codes!L$2:M$5
, 2, FALSE) which marks the row as complete if Column Y is set to YES.
I then created an IF statement =IF(C:C,"IN PROGRESS","") for Column B as I wanted an IN PROGRESS (in orange) to appear if a date was put into Column C in order to show that a new entry has been created.
I cannot seem to combine the two. As what I would like to happen is that a new entry is created and the Status Column 'A' populates 'In Progress', however once the dropdown in 'Posted?' Column Y is changed to YES, N/A or COLLECTED it changed to completed.
Can anyone help me on this please?