Referencing an unspecified cell

[toffee_madman]

Hi All

I'm currently working on a plan to update a table, where there are 10 cells per row which are all stages of completion (If you have done stage 2, then 1 and 2 are green), if 5 are done, 1-5 are green). I've want to make it so that for example, if the person has completed stage 8, he puts a "c" in box 8, and all the previous boxes get filled in as well.

Now, i can do this in Conditional Formatting as below - where i say if the 10th cell on Row A has a "C" make the previous 9 green...

Conditional Formatting code is =$T$10="c". Then the box becomes green.

Now the problem we have is i need to do this to all 9 in the first row, as well as hundreds of rows, i would have thousands of formatting rules to add.

Is it possible to make a Conditional Formatting along these lines....

Human Speak: "If the cell to your right contains "c", then make formatting changes."

In a nutshell, can you make a Conditional Formatting something like =CELL+1= "c"

Many thanks in advance for any help you can provide.