- Color Fill and Conditional Formatting
- Changing cell color with either conditional formatting or macro » Forum - Excel
- Conditional Formatting (more than 3) in Excel (Solved) » Forum - Excel
- VBA - Conditional formatting- Apply color to last column » How-To - Excel
- Excel conditional formatting row color (Solved) » Forum - Excel
- Conditional formatting before color sorting! (Solved) » Forum - Office software

Open a new tab in the browser!

As for condional formatting, see here:

http://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color

Have FUN!

As for condional formatting, see here:

http://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.

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.

True = true

what is so tough?

what is so tough?

- Member requests are more likely to be responded to.
- Members can monitor the statuses of their requests from their account pages.
- A CCM membership gives you access to additional options.

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