Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional color code

i am using RowNo()  as expression in table to show number of rows into the table.

I want to highlight the expression Lable of RowNo()  that is 'Rows' in yellow color when total is more than 150.

2 Replies
HirisH_V7
Master
Master

Hi,

Check like this,

Right click on chart -> Custom format cell -> and at background color your condition->

Column header Color Change in table-237949.PNG

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Frank_Hartmann
Master II
Master II

Hi,

use "Custom format cell" and then  edit "Background Color" by following calculated expression:

if(num(RowNo(),'###')>150,yellow(),)

hope this helps