Hello,
I have an Excel workbook where we track Jobs in and out of the Lab.
I am using Excel through Office 365.
Column A is the Status Column, As we enter data into certain columns this automatically updates the Status Column based on the formula for column A.
When I put a date into Column L "Rej. Date" the formula enters an "F" into Column A and Conditional Formatting changes the cell to Yellow.
When I put a Date into Column Q "Date Out" the formula puts a "C" into Column A and Conditional Formatting changes the cell to Green.
This works great if I do this independently of each other.
I need to add a step to the formula that will change Column A to C and Green when I have a date in both Columns L & Q.
Right now, if I have a date in both, Column A stays F and Yellow.
I have attached a sample workbook with two lines from actual workbook. The actual workbook is too large to attach.
Top Line shows the result when there is only a date in the Column Q. Second line shows the results when both are filled in.
Any help would be appreciated!
Thank you,
Stephen Meiring
The workbook wasn't attached. Please try again and don't forget to press 'Start upload' before you submit your reply.
Hello Riny van Eekelen,
Thank you for letting me know. Must of posted before it finished.
Should be attached now.
Thank you,
Stephen Meiring
Please have a look at the formula I entered in A15 (attached file). I added another IF in the beginning where it is checked if both cells are >0. If so, "C", if not, then execute your original formula. It seems to work, but please check for yourself.
Hello Riny van Eekelen,
That worked perfectly for me.
Thank you so much, I appreciate your time!
Have a good day!
Stephen Meiring