condition formatting

[avuong6]

i have the following workflow:

the output is:

how to search output, identify items in 'dateto' column starting with '9999', change format of those rows to yellow?

any help is appreciated.

[DataNath · Accepted solution]

Hey @avuong6, to format your outputs like this, you'll need to leverage the reporting tools rather than standard outputs. For conditional formatting, we can set this up using Row or Column rules depending on the scenario. Obviously for this, we want to create a row rule that highlights when DATETO starts with '9999' so we'll do that by going to 'Edit Row Rule' and creating one with the following condition:

STARTSWITH(TOSTRING([DATETO]),'9999')

Now, when you're outputting from reporting tools, you need to Render the final output. Here I've just used a temporary Excel file as I'm not interested in properly saving it. In your case, I'd use this to play around with the formatting until you have something you're happy with. Once done, you can switch the 'Output Mode' to 'Choose a Specific Output File' and save it truly as an Excel. Based on the condition and the mock data I've entered from a section of your screenshot, we get the following output:

Hope this helps - please do shout if you have any questions!

[avuong6]

that worked perfectly - thank you.

one last thing, how to code not starting with 9999?

[DataNath]

Hey @avuong6, great to hear! To do ‘NOT’ in Alteryx just use ! So it’d be:

!STARTSWITH(TOSTRING([DATETO]),'9999')