more than 3 conditional formatting

**ccsmith** · 08-31-2010, 08:02 AM

According to the attached sample I would need a macro which can solve my request:
- when I write NO in a cell the macro should be formatting the active cells and the next 2 cells to fill them with light grey colour.
The original woorkbook already contains more than 3 conditional formatting for these cells.

**johnjohns** · 08-31-2010, 08:14 AM

Before a macro solution comes from anybody, Excel 2007 and 2010 support conditional formatting at many levels

rgds
johnjohns

**ccsmith** · 08-31-2010, 08:24 AM

Where I have to use the workbook we have EXCEL 2003 and in it unfortuanetlly we could solve this question with macro.

**marc5354** · 08-31-2010, 10:26 AM

Hope This will help you....

Marc

**ccsmith** · 09-01-2010, 08:06 AM

marc5354: thank you for your solution but I would need some additional function to that.
If I enter the "NO" or some word (as your indicated that into your macro) the previous two cells has to be coloured.
Example: If I enter No in A12 I would like to see the A10 and A11 cells with the same colour.
Do you have solution for this?