ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cell Coloring (https://www.excelbanter.com/excel-worksheet-functions/163682-cell-coloring.html)

supersub15

Cell Coloring
 
Is it possible to colour the background of a cell depending on the
result of a formula? Example: If the result is "Within Limits", colour
the cell in green. If the result is "Outside of Limits", colour the
cell in red.


Frederik[_3_]

Cell Coloring
 
Yes.
With 'conditional formatting'.

"supersub15" schreef in bericht
ups.com...
Is it possible to colour the background of a cell depending on the
result of a formula? Example: If the result is "Within Limits", colour
the cell in green. If the result is "Outside of Limits", colour the
cell in red.




supersub15

Cell Coloring
 
On Oct 26, 11:04 am, "Frederik" wrote:
Yes.
With 'conditional formatting'.

"supersub15" schreef in oglegroups.com...



Is it possible to colour the background of a cell depending on the
result of a formula? Example: If the result is "Within Limits", colour
the cell in green. If the result is "Outside of Limits", colour the
cell in red.- Hide quoted text -


- Show quoted text -


Duh!

Thanks. That was easy...



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com