Official Politics Forum Off Topic thread

Status
Not open for further replies.
#5,403
#5,403
gcbvol said:
Based on on cell placement in your image, select the last nm and first nm cells together and apply new rule.

1) Choose 'Use a formula to determine..."
2) Enter the following as formula:
= OR($E2>=5, $F2>=5)
3) Choose desired format
4) Apply
5) Hopefully it works and you can copy down in columns A & B
Click to expand...

Nice, beat me to it. I was a la dentista
 
#5,405
#5,405
gcbvol said:
Ahh, yes. If you click in any of the A or B cells that has the formatting, then click Conditional Formatting button--> Manage Rules...

There will be a range listed under Applies to...

Change that range to include the full set of cells to apply e.g. =$A$2:$B$10

Click Apply
Click to expand...

One final question on this. If I add rows (new hires), will the formatting take that into account and automatically adjust to include those new rows?
 
#5,406
#5,406
Grand Vol said:
One final question on this. If I add rows (new hires), will the formatting take that into account and automatically adjust to include those new rows?
Click to expand...

It will not. What I usually do is extend the range to account for new rows. So instead of ending the previous range at $B$10, set it at $B$100, etc.
 
#5,407
#5,407
Grand Vol said:
One final question on this. If I add rows (new hires), will the formatting take that into account and automatically adjust to include those new rows?
Click to expand...

As long as you follow the format gcb gave you, manually adding adding those columns with it, it should carry over.

However, I don't use excel. I use Google's spreadsheets, which apparently work in a very similar fashion.
 
#5,418
#5,418
Other than the score, I really want to see this again tomorrow.

[youtube]https://www.youtube.com/watch?v=xFw81_tyXI4[/youtube]
 
  • Like
Reactions: 2 people
#5,423
#5,423
TNsnyper20 said:
Game day blouses!!!
Click to expand...

All week I've been listening to Arkansas sports radio with Bo Mattingly and Tyler Wilson. They have had several professional callers call in (fox, cbs,espn, etc) to discuss this weeks games.

All of them picked Oklahoma to win except some Vegas guy that they interviewed yesterday. He picked the Vols to win. 37-24.

They kept saying we don't have the depth to beat Oklahoma. We don't have the talent to beat Oklahoma.

I hope our boys make a statement today, and it shuts these people up!

Go Vols!!!!!
 
  • Like
Reactions: 2 people
#5,424
#5,424
Obsessed said:
All week I've been listening to Arkansas sports radio with Bo Mattingly and Tyler Wilson. They have had several professional callers call in (fox, cbs,espn, etc) to discuss this weeks games.

All of them picked Oklahoma to win except some Vegas guy that they interviewed yesterday. He picked the Vols to win. 37-24.

They kept saying we don't have the depth to beat Oklahoma. We don't have the talent to beat Oklahoma.

I hope our boys make a statement today, and it shuts these people up!

Go Vols!!!!!
Click to expand...

We'd have to go 15-0 just this year alone to garner "some respect" from some people & from other teams imo.
 
New posts
Status
Not open for further replies.

VN Store



Back
Top