Setting Cell Color within a Cell

[Darin Duphorn]

I'm using quick test professional which uses Excel
DataTables, but with half the functionality. I'm
basically exporting a the datatable from Mercury quick
test to excel. With in my quick test script I'm
performing a compare between two excel documents, and I
wish to represent the difference with a Red background.
Basically, Is they anyway in which I could add so code
within my cell that would automatically change the back
ground color.

Example:
My result is 4.13. I would then change this variable
within quicktest to something like vbRed.4.13. Then when
it gets sent to Excel the number with display 4.13 with a
Red background.

 

[Dave Peterson]

You may want to look at Format|conditional formatting to set colors.

There's nothing built into excel that will do what you're asking.

Debra Dalgleish has some nice notes at:
http://www.contextures.com/xlCondFormat01.html

that you may want to read.