[SOLVED] Conditional Format (color) of a Cell in Excel Output

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/666105335

September 24, 2010, 07:52 AM

Bennett

[SOLVED] Conditional Format (color) of a Cell in Excel Output

I know this is an easy one for you guys. Can anyone tell me how to make a cell a certain color in an excel report when you have a specific value? For example, if I was using the Car file and built a report with an excel output, how can I highlight only the cells that contain the make "Jaguar?" Thank you for your help.

This message has been edited. Last edited by: Kerry,

WebFOCUS 7.6.9
upgrading to Version 7.6.11
Windows
all output (Excel, HTML, PDF)

September 24, 2010, 08:12 AM

Tony A

Search for conditional formatting.

  TYPE=DATA, WHEN=CAR EQ 'JAGUAR', BACKCOLOR=GREEN, COLOR=WHITE, $
  TYPE=DATA, COLUMN=CAR, WHEN=CAR EQ 'JENSEN', BACKCOLOR=BLUE, COLOR=WHITE, $

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

September 24, 2010, 10:24 AM

Bennett

Thanks Tony.....worked perfect!

WebFOCUS 7.6.9
upgrading to Version 7.6.11
Windows
all output (Excel, HTML, PDF)