• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change color and value of a cell in A6 when the value in C6 is Yes else nothing

I am looking for a worksheet change event that fills Cell A6 with the value 15 25 and change the color to Yellow if cell value in cell C6 is yes and fills Cell A7 with the value 2 8 and change the color to blue if cell value in cell C7 is yes , if value is no then nothing
Thank you in advance
 
Hello,
I was a bit fast with my answer
I would like to change this
Code:
 If .Range("C6") = "yes" Then
Into something like this
Code:
  If Not IsEmpty(.Range ("C6").Value)
I do not find a solution
Thanks in advance
 
Back
Top