MariaFarag
New Member
- Joined
- Dec 30, 2019
- Messages
- 20
- Office Version
- 365
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
Hello
Please I need help with what formula to use for the below logic:
1. I usually insert quotation numbers of quotations that are not yet approved by clients - just to keep track (below image - 1)
2. when approved, I insert the quotation details and the other project details on the other sheet, the project list (below image - 2)
3. The formatting I want is for the row in the first sheet (image -1) to be highlighted in green when the quotation number in this sheet (column B) is found in the 2nd sheet's (image -2) column L
In other words, if I insert "SOF-2021-Q-001" in column L of the 2nd sheet, I want row 17 in the first sheet to be highlighted in green
Can someone help please?
Thank you in advance
Please I need help with what formula to use for the below logic:
1. I usually insert quotation numbers of quotations that are not yet approved by clients - just to keep track (below image - 1)
2. when approved, I insert the quotation details and the other project details on the other sheet, the project list (below image - 2)
3. The formatting I want is for the row in the first sheet (image -1) to be highlighted in green when the quotation number in this sheet (column B) is found in the 2nd sheet's (image -2) column L
In other words, if I insert "SOF-2021-Q-001" in column L of the 2nd sheet, I want row 17 in the first sheet to be highlighted in green
Can someone help please?
Thank you in advance