$$Excel-Macros$$ Re: filling cells with colours

Hi, Please find the attached workbook with the solution. Consider the Cell A1 and watch the Conditional Formatting logics. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, May 6, 2009 at 5:04 PM,

$$Excel-Macros$$ Re: filling cells with colours

Thanks to all On May 6, 7:19 pm, Harmeet Singh wrote: > Instead of vba use conditional formatting, would be better. > if u need help in conditional formatting for ur query then lemme know. > > On Wed, May 6, 2009 at 5:04 PM, xxx wrote: > > > I need help in writing this macro > > > if the cell c

$$Excel-Macros$$ Re: filling cells with colours

Instead of vba use conditional formatting, would be better. if u need help in conditional formatting for ur query then lemme know. On Wed, May 6, 2009 at 5:04 PM, xxx wrote: > > I need help in writing this macro > > if the cell content is empty fill it with Red > if cell content contains "Y" the

$$Excel-Macros$$ Re: filling cells with colours

Hi Try this, If ActiveCell.Value = "" Then With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 255 .TintAndShade = 0 .PatternTintAndShade = 0 End With Else If ActiveCell.Value = "Y" Then With Selection.Interior .Patt