extend conditional format

Hi There,
I have seen some posts on sophisticated extension of conditional formatting but those only took care of colors. what I would like to have is:

if cond1
-specify color
-specify bold or not
-specify italic or not
-specify cell color
-specify cell (not content) underline

if cond2, etc..

anyone?

thanks a lot,
jm

Thank you VBA Noob,

sorry for those neewbie VBA add'l questions::

- how is th sub called? do I need to run a macro? can this be applied automatically?
- How if I want to do the CASE on column A, and apply changes on columns B to D?
- what is the code to underline the cell border (vs. content)?

thx again,
jm

cool, getting there. Works great on the cell I ENTER a value on.

I would need however :

1: depending on what cell in Col A is, will change format in Cols B-D

2: should do this based on e.g. A1 which is a formula, i.e. I am not actually changing or entering anyting on A1. But depending on many other cells, A1 will have a value which I use to format B1 C1 and D1.

thx,
jm

PS: what is the code to remove the border?

Noob,

- Offset(0,n) takes care of one offset cell. how about doing it on several columns? (will change C AND D)?

- There is still a major difference with the regular "conditional formatting". The sheet I work on is purely a sheet of formulas based on other sheets. I am not typing anything into this sheet, but I need it to reformat itself. The code seems not to be able to do so. Maybe _change is not the right trigger? _Calculate maybe?

thx,
jm

here you go:

1. I am pasting the whole "data" worksheet with value from another XL workbook.
2. The "display" worksheet compiles info from "data" worksheet
2.1 One of the compilation is column A, which defines a type of format
2.1. Based on this format, I need to format columns B, C and D

Hope this is not too cryptic,
thx for your help,
jm

thanks a lot, works perfectly.
best regards,
jm