ExcelBanter - how can i change the colour of eg. datas more than 10%?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how can i change the colour of eg. datas more than 10%? (https://www.excelbanter.com/excel-worksheet-functions/100806-how-can-i-change-colour-eg-datas-more-than-10%25.html)

Nazli

how can i change the colour of eg. datas more than 10%?

Dear all,
i want to show some cells in another colour ( eg. numbers more than 10% in
red).how can i do this?

Don Guillett

how can i change the colour of eg. datas more than 10%?

have a look at formattingconditional formatting

--
Don Guillett
SalesAid Software

"Nazli" wrote in message
...
Dear all,
i want to show some cells in another colour ( eg. numbers more than 10% in
red).how can i do this?

Gord Dibben

how can i change the colour of eg. datas more than 10%?

FormatConditional Formatting

Gord Dibben MS Excel MVP

On Sun, 23 Jul 2006 05:29:01 -0700, Nazli
wrote:

Dear all,
i want to show some cells in another colour ( eg. numbers more than 10% in
red).how can i do this?

All times are GMT +1. The time now is 08:04 PM.