For questions about conditional formatting in spreadsheets.

learn more… | top users | synonyms

3
votes
2answers
70 views

Coloring cells according to the value to which its content is closest

I am trying to make a guide for my dragons on a game I play but I'm not quite sure how to code what I am trying to do. Link ex. if has values "Guardian"(C2:C100) and "Dragoness"(I2:I100) in its row ...
4
votes
1answer
31 views

How can we retain authorship when we copy/paste a comment?

We have comments in a Google Spreadsheet that were not originally written by us. The cells the comments are written in already have "Conditional format rules" applied to them (e.g., cell H2). We ...
0
votes
1answer
8 views

Conditional Formatting Referencing another Cell (and using addition)

I am tracking high school credit acquisition. Each trimester a student must earn 2 credits to remain on track. If Cell A1 is "trimester 1 total credits", and cell B1 is "trimester 2 total credits", I ...
3
votes
0answers
27 views

Is it possible to set up conditional formatted using Excel online?

As per the title really, is it possible to set up conditional formatted using Excel online? The cell's context menu doesn't have the option, and I can't find it in the ribbon either. Am I missing ...
1
vote
0answers
474 views

How can I get a cell to change it's value based on another cell's color?

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 ...
0
votes
0answers
14 views

Conditional format — copy format of another cell (Google Sheets)

I'm using Google Sheets spreadsheet, hope it's ok to ask about it here (in superuser). Chances are the methods to accomplish this might be different from Excel or LibreOffice, if it can be done at all....
-1
votes
0answers
20 views

Highlight the cells used in a formula in Google Sheets

I want to highlight the cells that're used in the formula of a given cell. Let's say I want to apply conditional formatting on B12 which has value =A12+C3. Now I want A12 and C3 to be highlighted.