For questions about conditional formatting in spreadsheets.

learn more… | top users | synonyms

3
votes
2answers
74 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 ...
3
votes
1answer
35 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 ...
0
votes
1answer
9 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 ...
1
vote
0answers
476 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
25 views

Format a cell if the person has not signed in by certain time of day

I have a sign-in sheet where attendees sign-in for their cases. I want to write conditional formatting for the cell to turn red if they have not signed in by 8:45am on the current date - so two ...
0
votes
0answers
20 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....