Log In
Register
Home
July 19, 2023
Offline
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
See Answer
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
The workbook wasn't attached. Please try again and don't forget to press 'Start upload' before you submit your reply.
July 19, 2023
Offline
Hello Riny van Eekelen,
Thank you for letting me know. Must of posted before it finished.
Should be attached now.
Thank you,
Stephen Meiring
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
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.
Answers Post
1 Guest(s)
