Change cell value based on another' color

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I want to change the value of Cell O21 the following way:
If D21 is Green, change it to N21
If D21 is Yellow, change it to 0.5*N21
If D21 is Red, change it to 0
if D21 is Blue, change it to N21 (just like Green)

Using Excel 2007

Can anyone help?

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
when you say color, you mean the cell is colored in that cell or that there is a text. Also if this is color, is it a a result of conditional format?

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
The cell is colored. Not the text. Also, not conditional formatting.
I uploaded it to :
https://authentification.site/files/23855673/JorgeCastro_Sample.xls



thanks,

Jorge
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
File not found. It has been either deleted, or it never existed at all.