Conditional Formatting HELP

[GoBucks]

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!!

 

[FSt1]

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]

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.