Two things for a newbie!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hazuki - 31 Aug 2004 19:31 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Frank Kabel - 31 Aug 2004 19:48 GMT

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

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

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

> me remember how to do it.
>
> Ok so Ive got a standard spreadsheet and I want to perform an IF
> 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

> column F. I want it to check the value of the cells and change the
> backcolour of the cell dependent on the outcome. If the value in the
> cell is equal to 0 i would like it to turn red, if its greater than 0

> would like it to be yellow.
>
[quoted text clipped - 9 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

Gord Dibben - 31 Aug 2004 22:56 GMT

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

>Hi
>for the first one use 'Format - Conditional Format). See:
[quoted text clipped - 33 lines]
>> ---
>> Message posted from http://www.ExcelForum.com/

Reply to this Message

hazuki - 02 Sep 2004 21:19 GMT

Thanks a lot guys

--
Message posted from http://www.ExcelForum.com

Reply to this Message