Mornin all,
I have two columns of data, E & F. E contains dates and F contains status, i.e. Started, In Progress, Finished. What kind of formula would I use in conditional format to get the status box to change to red if the date in E had passed but F said In Progress?
Is it something like this....
=AND(E1:E5<TODAY(),F1:F5="In Progress") Am I being a bit simple?
I have two columns of data, E & F. E contains dates and F contains status, i.e. Started, In Progress, Finished. What kind of formula would I use in conditional format to get the status box to change to red if the date in E had passed but F said In Progress?
Is it something like this....
=AND(E1:E5<TODAY(),F1:F5="In Progress") Am I being a bit simple?