Excel queries

[ah]

Hi;

Appreciate if someone could help me with this:

I have a spreadsheet that contains a column for the user to indicate whether
they want to "Update" or "delete" the request.

Please advice whether the following can be done:
a) When the user enter the value called "update" in the cell, then the excel
should automatically change the wordings in that row to "blue" color

b) When the user enter the value called "delete", then the excel should
strike through the whole row for me

Thanks in advance.

 

[Arvi Laanemets]

Hi

Conditional Formatting will do this. (Format>Conditional Formatting in
Excel2000, Home>Styles>Conditional Formatting in Excel2007)