Hello All,
Attached file has sample data in sheet 1 and desired output in another sheet.
I need to color cell based on certain conditions;
Attached file has sample data in sheet 1 and desired output in another sheet.
I need to color cell based on certain conditions;
- If date in the row is less than or equal to today, It should change color of all the cell prior to it as Green. Example Cell O3 has today's date. All cells in row 3 has been turned to Green.
- If any cell has TBD in it, All cell following it in the row should turn to PInk. Example Cell M5 has "TBD". All cells in Row 5 after TBD has turned to Pink.
- If in any row we have NA it should turn to Green, but only up to the point where it finds a future date. Example Row 6. Till cell O6 we either have NA or date less than TODAY, hence everything is in Green. But Cell P6 has date Greater than Today, so from that point onward we have cells in Pink.