Changing cells depending on previous column

Hi guys,

I'm having some troubles figuring out how to not change the cell value if the column to the left contains a certain term

As an example...

Column B starting at B3 has just a description
Bob
Bob
Bob
Bob
Grant

Column C starting at C3 has the number
7.4
8.5
4.5
7.5
3.5

Now I'm trying to get all of the numbers to be a minimum of 8 except the number that is adjacent to Grant. Grant can be anywhere in that list depending if there is only 3 lines or 6 lines. But, Grant is always the last line.

Currently I'm using this which changes everything to 8 and leaves the numbers greater then 8 alone. But this also raises Grant to 8 and I would like that number to be unchanged.

Please Login or Register  to view this content.

Any suggestions?

Looks like that works, thanks Richard!

Do you really want the result of 8 to be a text value? You don't need to enclose it with quotes.

Pete

Thats good to know actually. It would be a number, but later on in the macro it formats the entire sheet to change the colors, font sizes, etc... Its not causing any troubles at the moment but good information regardless