Hi I'm new to the forum and new to programming for excel. I am trying to organize a spreadsheet by filling in certain cells with certain colors.

First I want to find all the cells under the column titled "Code" (currently column B if that makes it easier) that contain "TI" (thats a capital i) and then in each of these rows color in the column titled "TN_Required_End" (currently column L) with the color green.

Next I want to find all the cells under the column titled "Type" (column F) that contain "D2" or "B3" and then in each of these rows check the column titled "TN_Planned_End" (column N) to see if it contains any characters (specifically to check if there is a date entered there). If there is a date, leave it alone. If there is no date, color it yellow.

Let me know if I need to clarify anything. Thank you