2 replies to this topic

[capboyz]

Use the most appropriate formatting technique to display Current Salary,Adjusted Salary and Net Salary that exceeds $50,000.00



How ? I need 3 different different formatting technique to display the exceeds.

Also

Provide appropriate validations to control unrelated data being input to the columns,

Maximum 7% of Increment

Edited by capboyz, 16 August 2006 - 03:23 AM.

[Scythar]

dont understand the question, are you referring to the socalled "conditional formatting" ??

[rc69]

Just select all the cells and use conditional formatting to change the bg-color on all cells that contain a value greater than 50,000. Then you can go mess around with data validation (located in tools>data validation i believe) to see if you can get the rest sorted out (it's been a while since i've used excel, but that's ruffly what i would do).