Help with possible Macro or IF Funciton

[jamessharpe]

Hi All,

I've created a spreadsheet with conditional formatting to colour the cell basedon the vale in the cell. I can’t for the life of me figure out how to in thenext cell input one of the 4 options based on the cells colour. Example:

All colours in cell are due to conditional formatting and will change dependenton value inputted.
If cell I3 is red I would like it to automatically inputKey Player
If cell I3 is yellow I would like it to automatically inputKeep Informed
If cell I3 is brown I would like it to automatically inputKeep Satisfied
If cell I3 is green I would like it to automatically inputMonitor

Thanks in advance for any help!

 

[Fluff]

Hi & welcome to MrExcel.
What are the CF formulae for I3

 

[horrellbt01]

i think you may be better off using what ever formula you used for the conditional formatting to get the results you are looking for rather than trying to use VBA based on color. Would be a lot cleaner that way.

 

[jamessharpe]

My CF formula is using the ones created not my own specificformula
Cell Value between * =Key!$A$10* and * =Key!$A$13* equalsfilling the cell I3 with the desired colour correspondence to the value.



Because of the format of the data in the cellwhich is *Number – Number* I have many rules but they are all the same as abovejust different selected

 

[Fluff]

In that case you can use something like
=IF(AND(I3>=Key!A10,I3<=Key!A13),"key player","")