How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?
I would like to colour the background of a row in Google Spreadsheets: For example: If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black. If cell Dx = title ...
We have applicants who come in and fill out a form via Google Forms. I have fields that auto-populate from the Response tab into a separate tab that is organized to fit our trackers. I am looking for ...
I am trying to set a conditional format in Google spreadsheets and I am having some difficulty. I am not sure if I should use a cell reference or if formula. In my first Sheet called "Roster" there ...
I am having trouble highlighting all cells in a column that do not contain the same text that is found in the first cell at the top of the column. I would like to accomplish this with a conditional ...
I use Google Sheets to schedule office appointments. I have set conditional formatting so that if the appointment time slot cells are empty, they are highlighted yellow. (This makes it easier to find ...
So I have three colors in column F, green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this? Here is a link to a ...