Using formatting in a formula

[Laura O'Brien]

Hi all,

My spreadsheet days are long behind me, and I can't figure out how to do something in Sheets.  I have a long "to-do" spreadsheet with several category headers and individual tasks listed under each.  I have highlighted important/urgent tasks in red text. 

I would like to collect all the red tasks in a separate sheet/tab so that they can be seen at a glance.  I'm thinking an =IF might work, but I don't know if I can tell the formula to look for red text and then copy/paste it into the new sheet.

Any ideas?

[Alexander Ivanov]

Hi!

Unfortunately you can do that only via Apps Script or Sheets API

_____________________________________________________________________________________________

You can hire me to set up your Sheets and create Scripts for you. Just write to me hi...@contributor.pw

Best, Alex

[Diego Ravecca]

Alexander is right.

I think best option is to have a helper column where you record the state, lets say state can be 0, 1, 2, 3. Then with conditional formatting you change the text cell according to this state.

The following process is much easier, select rows with state X, copy, etc

Best