Easy Contitional Formatting Question (I hope)

[Frank Bacchus]

All:

I have several columns in my spreadsheet, of which I would like to fill 2 columns with yellow if the value of one of the columns is "P". In the conditional formatting tool, I want to say "if the value in the column Q is "P", then fill Column Q and Column D with Yellow. In the formula (for the conditional format tool I said "=IF $Q:$Q EQ "P" ". I don't think this is correct. Can you please shed some light on this. Thanks.

frank

 

[Peter Bartholomew]

Assuming that it is the cells corresponding to each "P" in Column Q that you require to format, you could apply the conditional format to the range
=$D$3:$D$25,$Q$3:$Q$25
(comprising the union two columns) and based upon the formula
= ($Q3 ="P")

Note that this is based upon a reference with relative row and absolute column.

 

[Frank Bacchus]

Assuming that it is the cells corresponding to each "P" in Column Q that you require to format, you could apply the conditional format to the range
=$D$3:$D$25,$Q$3:$Q$25
(comprising the union two columns) and based upon the formula
= ($Q3 ="P")

Note that this is based upon a reference with relative row and absolute column.

Peter:

Thanks for the response. I am not sure where "=$D$3:$D$25,$Q$3:$Q$25" goes. Can you please amplify? Thanks.

frank

 

[Peter Bartholomew]

=$D$3:$D$25,$Q$3:$Q$25

It is the 'applies to' range of the conditional format. In this instance it is the combination (union) of the two columns you specified.