Hello all,

I want to build a macro in excel that will scan the unempty cells and color them accordingly.
e.g. if a cell contains the word 'hello' it will color it yellow etc.

any ideas?

Try this:

Change color index as needed.

Welcome to the Board!

You could also use Conditional Formatting-->Cell Value Is-->Equal To-->="Hello" Then Format-->Patterns-->Yellow.

Hope that helps,

Smitty

Hello all

I am new to macros in excel. I have a column that is currently empty but will be inputted with dates soon.

What i want to do is have two macros: one will go through the entire spreadsheet and select the rows that have a date in the aforementioned column cell AND hide that particular row. The other will do the opposite - it will unhide the rows that were previously hidden.

please help

y

ok

Here are 2 macros for you

Macro1 hides all rows containing numbers
as Excel interprits dates as numbers then these rows will be hidden
it looks for numbers in column A

HTH

David

macro2 unhides all hidden rows on the worksheet

Yaron,

You can also try Select Case in VBA. Something like...
sub ColorCells()
Do
Select Case ActiveCell.Value
Case "Hello"
'using shades code.
Selection.SpecialCells(xlCellTypeConstants, 23).Select
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With
Case ""
'Do Nothing or hide.
Case "Good-Bye"
'Do somthing else.
Case Else
'Catch everything else...do something...do nothing.
End Select
ActiveCell.offset(1,0).select
Loop Until (some end condition)
End Sub