Conditional formatting based on formula

[Drwats0n]

Hi All,

=$R4>Q4>$R4*1.1

I need to apply the above formula in conditional formatting to highlight the field if the above formula is met.
However, i need to apply the formula from row 4 to row 13 for both R column and Q column.

My question is, instead of going into each cell and update the formula in conditional formatting based on the row number that i need, is there a quicker way to let conditional formatting update the formula to match the row number that i need?

In non conditional formatting scenario, i simply just drag the formulas down to update the row number. But for conditional formatting what is the best way to do it?

Hope my explanation is clear, thanks all in advance!

 

[Krayna]

You should be able to use format painter - see this article for more info: How to Copy Conditional Formatting to Another Cell in Excel - Trump Excel

 

[Fluff]

Simply select Q4:R13 & then apply the format rule
Although you will need to lock the Q col
=$R4>$Q4>$R4*1.1

 

[Joe4]

If you select the entire range you want to apply it to first, then enter the formula as it applies to the very first cell in your range, Excel will automatically adjust it for all other cells, provided that you use the absolute/relative range referencing correctly.

So highlight all the rows you want to apply it to and enter this CF formula:

=AND($R4>Q4,$Q4>$R4*1.1)