Official Politics Forum Off Topic thread

Status
Not open for further replies.
#5,377
#5,377
Grand Vol said:
Trying to conditionally format cells based on a number in an adjacent column of cells. I've already applied conditional formatting to certain cells to highlight using the simple "Greater than" conditional formatting. But I want the names to highlight once a number in the adjacent cells reaches a certain point. I.E.

Example_zpsogkj3tbw.png


You can see the number highlighted in column E. I want the names in that particular row to highlight as well once that number in either E or F reaches greater than 5.
Click to expand...

You mean like this?
 

Attachments

  • IMG_20150911_105559558.jpg
    IMG_20150911_105559558.jpg
    18.4 KB · Views: 1
#5,378
#5,378
Nvm... Just noticed you wanted a different column highlighted. I just used conditional formatting on a two color scale to track the progress. From red to green when we hit out goals.
 
#5,380
#5,380
Grand Vol said:
Trying to conditionally format cells based on a number in an adjacent column of cells. I've already applied conditional formatting to certain cells to highlight using the simple "Greater than" conditional formatting. But I want the names to highlight once a number in the adjacent cells reaches a certain point. I.E.

Example_zpsogkj3tbw.png


You can see the number highlighted in column E. I want the names in that particular row to highlight as well once that number in either E or F reaches greater than 5.
Click to expand...

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
 
  • Like
Reactions: 1 person
#5,381
#5,381
Grand Vol said:
Sure...I think.

ETA: I'm pretty sure there's a custom formula for what I want it to do. I just don't know how to format it.
Click to expand...

I'm sure there's a way to have to reflect on a different column. I don't know the formula though. You can create what I had posted about using two different color to help yuo track your progress as a group though. Condition each cell or row for a specific number. At least that way once you've hit your required number as a group everything is nice pretty and green. Give you a sense of accomplishment.:hi:

Edit: going to try what GCB put above for myself as well.
 
#5,385
#5,385
I consider my job to be pretty dangerous. (steelworker) However, I have some guys over cutting down some trees around the house. The guy in the bucket truck was a good 75 feet up and somehow rather forcefully came out of the bucket. The harness he was wearing saved his life.

I'll take hot steel over tree cutter every day of the week.

Wear your harnesses guys.
 
#5,386
#5,386
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...

Instantly my favorite person! Although I had to change the 5 to a 6.

You are my new hero and get a treat.

01ffter.jpg
 
#5,396
#5,396
Obsessed said:
This is all the payment I would need.
Go Oklahoma State!!!
Click to expand...

I have to say, while last weekend sucked bad because of the heat, the little coeds running around in clothing that barely had enough material to make a washcloth was something to see.

I am a straight dirty old man. And unfortunately I wasn't able to take pictures. The "Girls of Oklahoma" thread would be rocking if I was able to do so.
 
#5,397
#5,397
gcbvol said:
LULZ. Happy to help and glad you caught my mistake with criteria.

A nipple ring though? :)
Click to expand...

I've got to figure out how to apply that conditional formatting to the entire Column A and B without having to retype it with the different cells. Right now it works for the first row, but I'll need to apply is against the entire sheet.
 
#5,398
#5,398
Grand Vol said:
I've got to figure out how to apply that conditional formatting to the entire Column A and B without having to retype it with the different cells. Right now it works for the first row, but I'll need to apply is against the entire sheet.
Click to expand...

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
 
#5,400
#5,400
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...
Say that again in English, por favor.
 
New posts
Status
Not open for further replies.

VN Store



Back
Top