clark_christie
New Member
- Joined
- Aug 13, 2005
- Messages
- 1
I am trying to write an IF statement that looks at colored cells. I have never used VBA and I am not sure if I have to use VBA to write this IF statement or not.
I want the if statement to do the following:
If cell, D56 is where I am writing if statement, I56=N and the range CV54:DA54 is the color yellow then D56="F" then "NF"
Could someone tell me if I can do an IF statement that does this or do I have to go into VBA, if I have to go into VBA how do I write that?
Thanks,
Christie
I want the if statement to do the following:
If cell, D56 is where I am writing if statement, I56=N and the range CV54:DA54 is the color yellow then D56="F" then "NF"
Could someone tell me if I can do an IF statement that does this or do I have to go into VBA, if I have to go into VBA how do I write that?
Thanks,
Christie