Conditional formatting based on conditions in row/column

[Sohdaw]

Hi,

I have a workflow where im looking at putting conditional formatting on the "Grand Total" and "% of Limit" rows, to highlight cell background as RED

a) any values in the two rows < 0 

b) if the limit in Grand Total is exceeded, eg. x > 100M. 

Note that i have used a union tool to join the rows 1 & 2 and 3 & 4 together.  

	Limit 100M
	Description	Date T-1	Date T	Date T+1	Date T+2	Date T+3
1	abc
2	def
3	Grand total	x	y	etc
4	% of Limit	A	B	etc

[ShankerV]

Hi @Sohdaw 

Yes, it will work if <0 also.

Please see the below.

Many thanks

Shanker V

[ShankerV]

 @Sohdaw 

Have amended the rule to work for percentage >100 also.

Please check whether it helps to reach your solution.

Many thanks

Shanker V

[Sohdaw]

Can you share the workflows so that i can take a look at how the reporting tool was formatted?

[ShankerV]

Hi @Sohdaw 

Attached.