I am a total novice - had only one Excel class - and don't use it much. I typed a copy of an expense report in excel to try and automate this instead of the guys at work doing it manually. Is there any way to change the format of a cell if it is write-protected? In particular I am looking to change the color of the font. The expense report is write-protected except for entering the amounts spent. I have it set up so that the first column is the description column (hotel, meals, airfare, gas, parking, etc.), then the next 7 columns are each day of the week, then the next column is a 'cash spent' column, and the last column is the total column. I was hoping to be able to flag a dollar amount in a cell by a different color if it was a 'cash spent' amount. The 'cash spent' would be the amount that the employee was reimbursed for. I was rather hoping to enter some kind of formula in each cell of the 'cash spent' column that would say something like 'if C4:I4 = 'red color', then add them together and enter sum in the cell.
Thanks for any help.
Thanks for any help.
