2 excel questions

[Guest]

I have a excel file for keeping track of project costs.
My file includes:
No., Date, Cost, Remarks, Project Cat.

my two questions:

1. On "project cat." i have name of each project so i can view costs of
certain project and to be ablt to sort data. I also apply a color to each row
according to what "project cat" is.
e.g. project A Blue, Project B Red

I was wondering is it possible some way to let excel look at the value in
"Project Cat." in a row and then apply a color to that row accordingly?!

2. The "No." field i have contains number from 1 till end. I was wondering
how can i let this cell add this number automatically, so there is no need to
add it every time to reduce time and error?!

Thanks in advance
Zee

 

[Bob Phillips]

I have a excel file for keeping track of project costs.
My file includes:
No., Date, Cost, Remarks, Project Cat.

my two questions:

1. On "project cat." i have name of each project so i can view costs of
certain project and to be ablt to sort data. I also apply a color to each row
according to what "project cat" is.
e.g. project A Blue, Project B Red

I was wondering is it possible some way to let excel look at the value in
"Project Cat." in a row and then apply a color to that row accordingly?!

Conditional formatting. See http://www.contextures.com/xlCondFormat01.html

2. The "No." field i have contains number from 1 till end. I was wondering
how can i let this cell add this number automatically, so there is no need to
add it every time to reduce time and error?!

Maybe =A1+1