Bold Specific Cell or Data with Color

[KamenRider]

Hi Guys,

Can you please assist me on how to make a certain cell or data to be bold type. And if possible to put color on it. Please see sample output below.

Looking forward for your response. Thanks,

Mar

[atcodedog05]

Hi @KamenRider 

How can we identify which row to color is it always the last row?

[binuacs]

@KamenRider you use the Table tool to bold a specific cell

[Akash__on]

i think you want something like this :👇

1) add the table tool 

2) click edit row rule

2) apply row rule 'when' : select row number or formula.

3) do the changes

I hope this helps. :)

[KamenRider]

Hi @atcodedog05 @Akash__on  @binuacs 

Yes it is on the last row of the 1st set of data or computation, therefore it does not rely on line 4 or 5 only but it may be located at a different row depending on the number of data per columns. There will more sets of data, maximum of 8 sets. Given below is 2 sets. I've checked using the table but it highlighted the entire row and it is dependent on what row. I'm not sure if we can use a formula tool or a way that a table tool can find a way to solve my inquiries. See sample attached as how it look like.

Hoping for your assistance guys.

Thanks,

Mar

[atcodedog05]

Hi @KamenRider 

Here is how you can do it.

Workflow:

Hope this helps : )

[OllieClarke]

@KamenRider 

How's this?

You can apply column rules to Debit and Credit Amt, and use the formula (swapping out Credit amt for debit amt if needed)

IsNull([Cust Number]) AND !IsNull([Credit Amt])

to trigger the colour and boldness:

Hope that helps,

Ollie

[KamenRider]

HI @OllieClarke @atcodedog05 @Akash__on @binuacs 

@OllieClarke , I like your solution since it is quite near to what I wanted however, I notice you created another column to group it. Those set of data are being combined using Union Tool. How I hope we can create a counter to identify the total to be able to create a group and mark it as bold and with color. Is this possible or any more ideas?

Looking forward,

Mar

[atcodedog05 · Accepted solution]

Hi @KamenRider 

Here is how you can do the grouping. Extended solution of @OllieClarke 

Hope this helps : )

[OllieClarke]

@KamenRider I created that column to output each table as its own row, if you want to do this then @atcodedog05 has you covered. If you just want to have all tables combined still with the highlighting in place, then applying the column rules as I showed should still work - you'll just end up with a single table rather than many :)