Exporting data to excel and adding conditional formatting

[Johanb26]

Hi guys,



I am have a bit of trouble and have no idea how to sort this out. I am exporting data from the database to an excel sheet. Then I want to apply conditional formatting to the data so values between a certain range should be a certain colour.

But nothing happens when applying the conditional format, or when just trying to fill a cell in excel. Only when repeatedly clicking fill cell in excel does the colour change. Also all the cells are in the number format.

[ItsMe]

...But nothing happens when applying the conditional format...

Can you post the code you are using to attempt conditional formatting?

[Johanb26]

Can you post the code you are using to attempt conditional formatting?

Not using any code to attempt the conditional formatting.

What I am doing is exporting a query to excel and then in excel use excel's conditional format option. Then I set the rule for example: format to type of colour where value is less than 30

[ItsMe]

Perhaps the cells in your spreadsheet need to be the correct data type. Do not really know too much about Excel.