Need help to change a cell color based on conditions

[Ken]

I use a spreadsheet that comes up with values, or worth, of items based on
many preset conditions. I want to improve the spreadsheet by adding a new
functionality. I want the spreadsheet to automatically highlite the cell in B
column as green, nothing, or red based on other conditions of cells in that
same row. You with me so far?

Here is the scenario. Ccell's value is calculated based on other cells in
the sheet/book. Acell's value is manually input daily. Bc=Cc-Ac; Ccell minus
Acell is displayed in the Bcell of the same row.

I want to be able to see buying, selling, and ingore opportunties quickly
because the cells in B column will become automatically highlited based on
the relationship between Bcell and Ccell in each row.

The following conditions should be met in any given row:
If Bcell(Ccell minus Acell) is less than or equal to Ccell*.85 make the
Bcell green.
If Bcell(Ccell minus Acell) is greater than or equal to Ccell*1.10 make the
Bcell red.
If Bc is between Cc85% and Cc110% leave it white.

I have attempted to explain this as best I can without getting in trouble
for sharing proprietary information or methods. I Appreciate your taking the
time to read this. Thank you also for spending a little time to help me
accomplish this task. It will mean good things for me and my family if this
process can be implemented.

(K)

 

[shail]

I use a spreadsheet that comes up with values, or worth, of items based on
many preset conditions. I want to improve the spreadsheet by adding a new
functionality. I want the spreadsheet to automatically highlite the cell in B
column as green, nothing, or red based on other conditions of cells in that
same row. You with me so far?

Here is the scenario. Ccell's value is calculated based on other cells in
the sheet/book. Acell's value is manually input daily. Bc=Cc-Ac; Ccell minus
Acell is displayed in the Bcell of the same row.

I want to be able to see buying, selling, and ingore opportunties quickly
because the cells in B column will become automatically highlited based on
the relationship between Bcell and Ccell in each row.

The following conditions should be met in any given row:
If Bcell(Ccell minus Acell) is less than or equal to Ccell*.85 make the
Bcell green.
If Bcell(Ccell minus Acell) is greater than or equal to Ccell*1.10 make the
Bcell red.
If Bc is between Cc85% and Cc110% leave it white.

I have attempted to explain this as best I can without getting in trouble
for sharing proprietary information or methods. I Appreciate your taking the
time to read this. Thank you also for spending a little time to help me
accomplish this task. It will mean good things for me and my family if this
process can be implemented.

(K)

Dear Mr Ken,

Use "Conditional Formatting" under the menu "Format" and place the
formula and the desired colour setting.

I hope this helps.

Kind regards!