Need to set a Cell value base on other cells

Microsoft Office excel 2007 - upgrade
May 18, 2010 at 12:12:07
Specs: Windows XP, Intel Core i5 2.66
My son has made a spreadsheet of video games that he and his brother own/share. The sheet contains Title, price paid, a column for each of the brothers (A and K), and Sell.

They each put an "X" in the A or K field if it is a game they both play. He wants to set a value (i.e "*") in the Sell cell if neither the A or K cells contain an "X". This will yield a list of games which they can sell/trade.

I also want to format change the Title to Red and Bold. I can do that easily based on the Sell value, but can't figger out how to set the Sell value.

I am not wed to using "X" or "*" as the values for the condition if other values would work better.

Thanks for your assistance.

See More: Need to set a Cell value base on other cells

May 18, 2010 at 12:32:43
Let's say "A" is column A and "K" is column B.

In your Sell cell try this:


or anything beside the * that you want to use.

I assume you know that you can use Conditional Formatting to set the Font Color or Bold format based on whether there is a * in the Sell column or not.

If not, come on back and we'll explain it to you.

Report •
Related Solutions

Ask Question