Format cells from random numbers

[alfaspud]

Hi

I am trying to work out a way of conditionally formatting individual cells which are determined randomly when a spreadsheet is opened

I am using RANDBETWEEN to pick 5 numbers, eg. 3, 5, 18, etc
I then want to conditionally format cells C3, C5, C18

Is this possible using formula or do I need VBA?
Is it possible to insert a value into these cells by combining "c" with the random number?

I've been playing around with INDIRECT and CELL in conditional formatting formulas but can't seem to get anything to work

Thanks

 

[alfaspud]

Rick & footoo

Many thanks for your replies - I'll try them out and hopefully learn something in the process

Alfaspud