ExcelBanter - Cell Colour

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Cell Colour (https://www.excelbanter.com/excel-programming/377162-cell-colour.html)

Steve

Cell Colour

Is there a way to change the colour of a cell as part of a formula

ie: =IF(SUM(F5:F8)<100, change the colour of
cell,IF(SUM(F5:F8)=100,100),SUM(F5:F8))
Thanks for any help I can get

Steve

ChristopherTri

Cell Colour

Use conditional formatting from the format menu. It will allow you to alter
the format of a cell for three different conditions.

Regards...

"Steve" wrote:

Is there a way to change the colour of a cell as part of a formula

ie: =IF(SUM(F5:F8)<100, change the colour of
cell,IF(SUM(F5:F8)=100,100),SUM(F5:F8))
Thanks for any help I can get

Steve

All times are GMT +1. The time now is 04:12 AM.