• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Easy Contitional Formatting Question (I hope)

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.
 
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
 
Top