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.
Let's say "A" is column A and "K" is column B. In your Sell cell try this:
=IF(AND(A1="",B1=""),"*","")
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.