Formula or Conditional Formatting? Cut and paste based on font color in another cell

  • [TABLE="align: center, border: 1, cellpadding: 1, width: 8, height: 15"]

    [tr]


    [td]

    Amount

    [/td]


    [td]

    Collected

    [/td]


    [td]

    Invoice Number

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    100

    [/td]


    [td]

    18007716

    [/td]


    [/tr]


    [tr]


    [td]

    500

    [/td]


    [td][/td]


    [td]

    18007145

    [/td]


    [/tr]


    [tr]


    [td]

    200

    [/td]


    [td][/td]


    [td]

    18007711

    [/td]


    [/tr]


    [/TABLE]
    Hi Guys,



    Asking for help again.


    What should be the formula (or conditional formatting?) to use if the font in invoice number column is red, cut the value in Amount column and paste it in Collected column?


    By the way, invoice number font color is based on conditional format I put.



    Regards,


    Sam15

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!