Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Coloring of cell when entering data | New Users to Excel | |||
Tracking progress and coloring numbers in a cell | Excel Discussion (Misc queries) | |||
conditional cell coloring | Excel Worksheet Functions | |||
conditional cell coloring | Excel Discussion (Misc queries) | |||
Coloring Active Cell | Excel Worksheet Functions |