formatting cell

Hi All I really need your help. I have an inventory in and out log. It logs date an asset was issued and date it was returned. I have everything in a drop down menu and i need the following. these assets are loaned out on a daily basis and returned on a daily basis. (Or supposed to be) there...

Hi, As the title suggests, I created a spreadsheet to keep track what bills my roommates owe. I have columns/cells that tell say what bills each individual owes. The trouble I am having comes in when trying to format cells so that they will tell me what bills people still owe after paying...

I have 2 columns A2:A50 & H2:H50 containing NAMES & 'backgrond color + font color'. If A53 is filled with MATCHING EXACTLY any of A2:A50 then same backgrond color + font color should appear in H53 (output cell address). Ex: A2=SAM H2= background color yellow & font color Red A3=JUman H3=...

hi, i have a requirement where i have to format the row based on the input in Column A also i have to lock few cells of that Row based on the input. for Example say the Data entered in column 'A' is 'MAIN', then i need to change the color of that row and also lock Cells of C,D and E for that...

SHORT VERSION: I have a column for date of draft depending on date of load. I want to be able to have the DRAFT date automatically filed after entering the date LONG VERSION: So I started helping out at a fuel company and I was bragging about being good at excel. I didn't know nearly as much...