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 ...
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 ...