Forum

Notifications
Clear all

Formula Help

5 Posts
2 Users
0 Reactions
84 Views
(@steveo0707)
Posts: 28
Trusted Member
Topic starter
 

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

 
Posted : 20/07/2023 12:23 pm
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

The workbook wasn't attached. Please try again and don't forget to press 'Start upload' before you submit your reply.

 
Posted : 21/07/2023 12:33 am
(@steveo0707)
Posts: 28
Trusted Member
Topic starter
 

Hello Riny van Eekelen,

 

Thank you for letting me know. Must of posted before it finished.

 

Should be attached now.

 

Thank you,

 

Stephen Meiring

 
Posted : 21/07/2023 3:14 pm
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

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.

 
Posted : 22/07/2023 1:36 am
(@steveo0707)
Posts: 28
Trusted Member
Topic starter
 

Hello Riny van Eekelen,

 

That worked perfectly for me.

 

Thank you so much, I appreciate your time!

 

Have a good day!

Stephen Meiring

 
Posted : 22/07/2023 7:20 am
Share: