Hello all,
I'm not sure if this is the place to ask this question, but I am having some issues with the Google Docs version of Excel. I'm sure you all know that it is lacking in features, but I'm going to admit - I don't know how to do this particular function in Excel either.
Anywhosers, I am making a spreadsheet for my employer and I to show which jobs I have/have not done, and which jobs she has paid me for. She is a photographer, and I edit photos, post blogs, and whatnot for her. So, what I'm wanting to do is show which jobs she has given me and which ones I have not completed.
For example, I have Column A and Column B that are the jobs she HAS GIVEN me. So in this instance, she has given me two Edits and one Blog. Column C and D show which jobs I HAVE DONE and HAVE NOT DONE. In this case, I have finished the two Edits, but have not finished the Blog.
What I'm wanting to do is have the cell F3 turn red because there is an X in cell B3. Basically, I want the cells in columns C and D to change to red if it's corresponding "assigned" cell in columns A or B has it marked as being assigned. If the cell in column A or B are blank, then I want the corresponding cell in column C or D to remain the same color.
In English now - I want to look at this spreadsheet and see (by show of color) which jobs I have not done that she has assigned to me. I want that particular cell to pop out at me so that I don't miss seeing an empty cell and never complete the job.
__Col A_____Col B_______Col C________Col D
1 _Edit_______Blog______Edit DONE_____Blog DONE
2 _____________________________________________
3 __X_________X___________X___________________
4 __X_____________________X____________________
Help would be greatly appreciated!! I apologize for the novel - just wanted to make sure it made sense. Hopefully it does!
And excuse my attempt at making a spreadsheet in this post! Haha
-Kailey
I'm not sure if this is the place to ask this question, but I am having some issues with the Google Docs version of Excel. I'm sure you all know that it is lacking in features, but I'm going to admit - I don't know how to do this particular function in Excel either.
Anywhosers, I am making a spreadsheet for my employer and I to show which jobs I have/have not done, and which jobs she has paid me for. She is a photographer, and I edit photos, post blogs, and whatnot for her. So, what I'm wanting to do is show which jobs she has given me and which ones I have not completed.
For example, I have Column A and Column B that are the jobs she HAS GIVEN me. So in this instance, she has given me two Edits and one Blog. Column C and D show which jobs I HAVE DONE and HAVE NOT DONE. In this case, I have finished the two Edits, but have not finished the Blog.
What I'm wanting to do is have the cell F3 turn red because there is an X in cell B3. Basically, I want the cells in columns C and D to change to red if it's corresponding "assigned" cell in columns A or B has it marked as being assigned. If the cell in column A or B are blank, then I want the corresponding cell in column C or D to remain the same color.
In English now - I want to look at this spreadsheet and see (by show of color) which jobs I have not done that she has assigned to me. I want that particular cell to pop out at me so that I don't miss seeing an empty cell and never complete the job.
__Col A_____Col B_______Col C________Col D
1 _Edit_______Blog______Edit DONE_____Blog DONE
2 _____________________________________________
3 __X_________X___________X___________________
4 __X_____________________X____________________
Help would be greatly appreciated!! I apologize for the novel - just wanted to make sure it made sense. Hopefully it does!
And excuse my attempt at making a spreadsheet in this post! Haha
-Kailey
