The conditional-formatting tag has no wiki summary.
2
votes
1answer
110 views
Conditional formatting based on cell values in same column
In Google Spreadsheet, how do I change a cell's background color to red if the date in the cell matches the date in another cell in the same column? Column E in my spreadsheet is a list of due dates ...
1
vote
1answer
490 views
Is it possible to add conditional formatting when number changes?
This is probably not possible but...
I'm looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings)
So when the number in a cell is changed, ...
1
vote
2answers
117 views
Conditional formatting color gradient in Google Spreadsheet
A few friends and myself have created a Google Spreadsheet document where we are keeping track of virtual item sales. One column has costs, one column has income one has profit, and a fourth has a ...
1
vote
0answers
54 views
Conditional formatting for dates in Google sheets
I work at a language school and I have a column giving the students expected arrival date.
I want to set conditional formatting to:
Highlight in red any date that is older than 1 week
Highlight in ...
2
votes
1answer
238 views
Google SpreadSheet conditional formatting based on number of characters
In Google Spreadsheet, is there a way to conditionally format a cell if it has more than 30 characters?
4
votes
1answer
207 views
Google Spreadsheets Conditional Formatting with color
I want to add a column of cells together only if the particular cell is colored green. Can I do this using conditional formatting on a google spreadsheet?
34
votes
3answers
36k views
Google Spreadsheets conditional formatting based on another cell's content
How can I set conditional formatting on a particular cell that depends on another cell's value?
A | B
1 | x
2 |
3 |
1 | x
1 | x
4 |
8 |
// X can be any value and is here merely to
// mark the ...
