Color Fill and Conditional Formatting
Closed
jmg999
Posts
3
Registration date
Thursday February 8, 2018
Status
Member
Last seen
February 10, 2018
-
Updated on Feb 8, 2018 at 04:36 PM
Blocked Profile - Feb 12, 2018 at 04:46 PM
Blocked Profile - Feb 12, 2018 at 04:46 PM
Related:
- Color Fill and Conditional Formatting
- Notepad++ background color - Guide
- Sound card color code - Guide
- Rg45 color coding - Guide
- Powertoys color picker download - Download - Other
- Html text color - Guide
2 responses
Open a new tab in the browser!
As for condional formatting, see here:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
Have FUN!
As for condional formatting, see here:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
Have FUN!
"checked out the link you'd provided, and I understand the directions, but I do not understand what formula I would have to put into the description box in order to achieve the result I want."
Any formula that returns true.
A1=5
B1 =4
Formatting formula:
=if(a1>B1,True)
If you set a format for green, that cell would be green. In the case of multiple formulas (i have nested 15 before), it is always the last True that wins. So if you are working with values, always inspect from Least to Most Significant.
Any formula that returns true.
A1=5
B1 =4
Formatting formula:
=if(a1>B1,True)
If you set a format for green, that cell would be green. In the case of multiple formulas (i have nested 15 before), it is always the last True that wins. So if you are working with values, always inspect from Least to Most Significant.
jmg999
Posts
3
Registration date
Thursday February 8, 2018
Status
Member
Last seen
February 10, 2018
Feb 10, 2018 at 08:41 PM
Feb 10, 2018 at 08:41 PM
I'm really not understanding what you're getting, as I've tried to explain, since I'm not at all familiar w/ Excel formulas. I appreciate the time you've put into this, so I thank you for that, but I'm going to try another forum.
Feb 9, 2018 at 01:19 AM
Thank you for your reply. There must be a bit of a misunderstanding regarding my Google Docs question. When I open Google Drive on my iPad, and I open the spreadsheet, it opens a Google spreadsheet document w/in Google Drive. It's not in a browser window. Therefore, if I hit the home button, it closes the spreadsheet, so when I go back to it, I have to re-open it each time. I'm trying to figure out a way to avoid closing it, when I have to switch between applications.
I checked out the link you'd provided, and I understand the directions, but I do not understand what formula I would have to put into the description box in order to achieve the result I want. I read some of the other links underneath the OP's post, and one of them seemed to point me in the right direction, but ultimately, it didn't meet my needs.
Let me see if I can explain what I want a little bit better...In this spreadsheet, I have data stretching from columns A through P and rows two through 443, where row one is a fixed header. The only column that does not contain data is column B. As the data is vetted, I type "ok" into column B. I then highlight the entire row from column A to column P, and I fill it w/ a light green color in order to easily see that this data has been validated. I hope this makes sense.
Jeff