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