on 01-04-2010 5:01 PM
Hi,
I have a requirement wherein I need to conditionally format column to make the coulmn value "red colored" as per a certain condition and also need to display a small image next to the column value. Does anybody have an idea to achieve this?
Thank you,
boe user1
Hi,
As rohit said, for conditional formating we can go for alerters. In menu bar Format-> alerters -> add ur conditions -> select the required background/fore ground colors for the data.
To display a image you can add one more column and insert it as a background image. If this is also conditional then again insert it using alerter or you can write if else formula with image url.
Cheers,
Suresh Aluri.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use Alerters for the conditional formatting.
Click on the Alerter icon from the tool bar.
New-> define condition -> click ok for default formatting else click on format.
You can define any formatting to the column values you want e.g you can change the font color or you can change the back-ground too.
To display a image you can add one more column and insert it as a background image. If this is also conditional then again insert it using alerter or you can write if else formula with image url.
Regards,
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.