Fill cells with different colors based on different cell contents

[mdeibel]

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

[Wagstaff]

Hi,

You could use conditional formats applied to columns L and N

[Wagstaff]

You could use this in excel 2007

In L2 enter the following conditional format, select formula

Please Login or Register  to view this content.

Select background as green

Then do the same in N2 but use

Please Login or Register  to view this content.

Select background as yellow

Then copy formats down each column

If you really need code then maybe someone else can advise.

[mdeibel]

Thanks for the advice. But I really need it coded...