IF Statement in Conditional Formatting

[wangaa11]

Hello,

In Column G I am trying to highlight the row yellow when "Apple" appears but in column F when it says sold I want the highlight to be removed. I was hoping to be able to add a conditional format to the sheet since there are several rows of data.

 

[Joe4]

Highlight all the rows you want to apply this too, then write the Conditional Formatting according to the very first row in your selection.
So, if you started on row 3, the formula would look like:

=AND($G3="Apple",$F3<>"sold")

and then choose your highlighting option.

So it would only be applied when column F is "Apple" and column G is NOT "sold".

 

[wangaa11]

Highlight all the rows you want to apply this too, then write the Conditional Formatting according to the very first row in your selection.
So, if you started on row 3, the formula would look like:

=AND($G3="Apple",$F3<>"sold")

and then choose your highlighting option.

So it would only be applied when column F is "Apple" and column G is NOT "sold".

Thank you! that worked

 

[Joe4]

You are welcome!

The key is to put the $ in front of the column reference to lock it down, so it applies to all columns in the row without shifting.