Two things for a newbie!

[hazuki]

Firstly hello to all, I'm sure this will be an easy one but I haven'
used Excel in years so i know it can be done but can't for the life o
me remember how to do it.

Ok so Ive got a standard spreadsheet and I want to perform an I
statement followed by THEN (I think thats right) on a column of cells
For arguments sake lets say i want it to run on the first 100 cells i
column F. I want it to check the value of the cells and change th
backcolour of the cell dependent on the outcome. If the value in th
cell is equal to 0 i would like it to turn red, if its greater than 0
would like it to be yellow.

Secondly I would like a command button that automatically insert
todays date into a given cell.

Hopefully you will be able to answer these two questions.

Many Thanks in advance

hazuk

 

[Frank Kabel]

Hi
for the first one use 'Format - Conditional Format). See:
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

 

[Gord Dibben]

For the second one....

You can hit CRTL + ;(semi-colon) to enter a static Today's date in a cell.

If you want a Command Button macro.........

Sub NOWDATE()
ActiveCell.Value = Format(Date, "dd-mmm-yy")
End Sub

Gord Dibben Excel MVP

 

[hazuki]

Thanks a lot guys