Macro to fill the color in particular cell

**judethomas** · 03-24-2012, 01:40 PM

Hi Peers,

I have data in the columns A,B,C and D of 'Orders' Spreadsheet. The Column D is ‘Order Type’. I have made a drop down list in this column D where 3 options are available i.e UPDATE,FULL SEARCH & REGULAR . If I select REGULAR from this list the cells in that particular raw in the columns A,B& C should be filled with Green color .And in the next raw if I select FULL SEARCH the cells in that particular raw of columns A,B & C should be filled with Red color.

I need your help to create a macro for this requirement.

Thanks in advance....

JT

**protonLeah** · 03-24-2012, 02:45 PM

Use conditional formatting on columns A - C, using as a condition, D="x", where x is the value from the dropdown list. For instance, for row 1:

=D1="Regular"

would be the condition formula and select green for the fill color.