cancel
Showing results for 
Search instead for 
Did you mean: 

How to Set cell colour based on other cells?

Former Member
0 Kudos

I need to configure an "excel style" grid.

In the grid I want to set the cell colour based on another cell value (i.e. If Column1 < column 2 colour it red)

Is javascript the only way to do this ???

If so , does anyone have an example of how to so this using javascript.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Chris,

select the iGrid subtype "Scoreboard" to use cell level color highlighting. Then use JavaScript to set the matching colors.

Here are some threads about this:

[Change color of a single cell in a grid|http://forums.sdn.sap.com/click.jspa?searchID=49244180&messageID=8066954]

[Scoreborad iGrid color context|http://forums.sdn.sap.com/click.jspa?searchID=49245904&messageID=7864589]

[SAP Help: iGrid Color Context Properties|http://help.sap.com/saphelp_xmii120/helpdata/en/44/cf149e3afb6f1ee10000000a155369/frameset.htm]

Michael

Former Member
0 Kudos

Hi Chris,

You can also use XSLT to set color of a cell based on the values of other cells.

Best Regards,

Kedar

Former Member
0 Kudos

Thanks ... xslt was the answer

Answers (0)