I am looking for a conditional formatting formula that will accomplish the
following in the table example below:


Col1 Col2 Col3 Col4 Col5 Col6 €¦... Col50
Row1 xx 10 10 10
Row2 xx 100 100 100 100
Row3 xx 50 50
......
Row100 xx 60 60 60

I have an range of data from C2:101. In each row I would like to
conditionally format the cells to the left of the last value input in the row
back to the cell in Col 3. For example; Row1 would have CF from Col4 back to
Col3; Row2 would would have CF from Col5 back to Col3; Row3 would be CF for
Col3 only..etc. Assume that all cells right of the last value are blank.

Is this possible? Thanks!!

hi
high light the range you wish to have conditional formating ie per your
example C1:AX101??? or what ever range you want to have CF.
for the CF...
cell value is.....not equal to.......=""

in other words, if the cell has a value(any value, number or letter) then
apply CF else if cell value is empty then don't apply CF.

regards
FSt1


"GoBucks" wrote:

I am looking for a conditional formatting formula that will accomplish the
following in the table example below:


Col1 Col2 Col3 Col4 Col5 Col6 €¦... Col50
Row1 xx 10 10 10
Row2 xx 100 100 100 100
Row3 xx 50 50
.....
Row100 xx 60 60 60

I have an range of data from C2:101. In each row I would like to
conditionally format the cells to the left of the last value input in the row
back to the cell in Col 3. For example; Row1 would have CF from Col4 back to
Col3; Row2 would would have CF from Col5 back to Col3; Row3 would be CF for
Col3 only..etc. Assume that all cells right of the last value are blank.

Is this possible? Thanks!!

Thank you for your response. I do not think that this will accomplish what I
was hoping. Basically, I was looking to CF the cell values in a row range to
the left of the last cell value input in that row. I know that this is
probably pretty tricky to do.

"FSt1" wrote:

hi
high light the range you wish to have conditional formating ie per your
example C1:AX101??? or what ever range you want to have CF.
for the CF...
cell value is.....not equal to.......=""

in other words, if the cell has a value(any value, number or letter) then
apply CF else if cell value is empty then don't apply CF.

regards
FSt1


"GoBucks" wrote:

I am looking for a conditional formatting formula that will accomplish the
following in the table example below:


Col1 Col2 Col3 Col4 Col5 Col6 €¦... Col50
Row1 xx 10 10 10
Row2 xx 100 100 100 100
Row3 xx 50 50
.....
Row100 xx 60 60 60

I have an range of data from C2:101. In each row I would like to
conditionally format the cells to the left of the last value input in the row
back to the cell in Col 3. For example; Row1 would have CF from Col4 back to
Col3; Row2 would would have CF from Col5 back to Col3; Row3 would be CF for
Col3 only..etc. Assume that all cells right of the last value are blank.

Is this possible? Thanks!!