Conditional Format - dynamic range

[ionelz]

A1=23
A2=4

I want to put a Conditional Format (fill range with a color) from A5 to 4 cells to right and 23 cells down

[63falcondude]

Highlight A5:Z100 (or however far you expect the Conditional Formatting to go > Conditional Formatting > New Rule > Use a formula
=AND(COLUMNS($A:A)<=$A$2+1,ROWS($1:1)<=$A$1+1)
Format: Fill color of your choice > OK > OK

This assumes that by "4 columns to the right", you didn't want to include column A. If you did, get rid of the +1's.

[Fluff13]

The refersto range needs to be absolute range.
Even if you enter a named range in the refersto box, it will be converted to a static range.