Please could somebody help me with a problem. I have a spreadheet and I would like make some cells in a row go yellow if they have no data in them. the data will either be text or a date. This is to highlight if ALL information on a spreadsheet row has NOT been entered or has been left out (the row info will be entered over a period of time)
If this cannot be done do you know how to just make one cell turn yellow if there is no date entered?
I have tried using conditional formatting but I can't figure this out.
I have daily logs that track issues/problems with our equipment. I have a cell that we enter in the time/data the issue was fixed. What I want to do is have the rows without any information in the time/date cell highlight a specific color.
If this can be done in conditional formatting please tell me how.