# Easy Contitional Formatting Question (I hope)

#### Frank Bacchus

##### Member
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

##### Well-Known Member
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

##### Member
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

##### Well-Known Member
=\$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.