Question Conditional Formatting Rules Manager

[Burnsie]

Afternoon.

I have a spreadsheet where certain cells are formatted to change colour depending on the values in them.

For example, one column is for cholesterol and depending on the cholesterol level the text in the cell will change from Green, to Yellow to Red.

I have also started managing all my data in an Access datasheet,

To get the data into my original spreadsheet I export it into an Excel format then copy and paste the data I want into my spreadsheet.

However, this overrides my original formatting of the blank cell so all the number stay black.

Is there any (quick) way around this?

Many thanks

B

 

[ghudson]

Why not do it all in Access? Creat a report based off of your table data and use conditional formatting in the report.

 

[Burnsie]

Why not do it all in Access? Creat a report based off of your table data and use conditional formatting in the report.

To be honest, where i work, (even though we are a large organisation), we have very poor IT support department. To create the database I had to build it myself. I was therefore unsure as to what Access could do and had already set yup and been working with Excel for months.

 

[DCrake]

When you do your paste do a paste special and choose values only. It may be a simple paste is overridding you conditional formatting of the cells.