Conditional formatting rules linking to cells

[Mountain99]

Hi

I have a condition that uses the following formula:

Please Login or Register  to view this content.

It sets out if a cell in column R = > $1.0m potential impact and in the same row if the cell in column T has a value less than 1000000 then the condition is TRUE.

I would like to make this more dynamic. So I can build the model and substitute for different thresholds. e.g: > $20.0m potential impact and subsequently a value <20000000.

I therefore am linking to a cell.....so my new formula looks like this.....

Please Login or Register  to view this content.

Where C5 contains > $1.0m potential P&L impact
and C23 contains 1000000

but this is not working. Any ideas please?

Much appreciated

PS I attach test 3 model as an example

[FDibbins]

Try this instead...
=COUNTIFS($R$5:$R$183,$C$5,$T$5:$T$183,"<"&$C$23)+COUNTIFS($R$5:$R$183,"=< $1.0m potential P&L impact",$T$5:$T$183,">1000000")

[Mountain99]

Thank you FDibbons! Worked perfectly.....sorry not allowed to give anymore reputation to you!