formatting cell number positive_negative

[xam99]

Hi to all.
In colums C the cell format is:
'[Blu]+ 0,000;[Rosso]- 0,000 (italian)
'[Blu]+ 0,000;[Red]- 0,000 (english)
how to format adjacent column B with the same color?
thanks you
xam

[Pete_UK]

Have you tried using the Format Painter icon? Select the cells with the format you want, click the Format Painter, then move the cursor to the first cell where you want the format to be used, then click on that cell.

Hope this helps.

Pete

[TMS]

Conditional Formatting. Plus blue, minus red.

[mstark17]

You can use a conditional format only on column B. select the entire section of column B that you will use and click on conditional formatting and select "New Rule" then "Use a formula to determine which cells to format" and use the formula below

Please Login or Register  to view this content.

for red

Please Login or Register  to view this content.

for blue

I've attached your sheet below showing it. Thanks

[xam99]

Thanks to all

[TMS]

You're welcome.