UpTheArgyle
Board Regular
- Joined
- Jan 12, 2006
- Messages
- 179
Hi
Trying to format a cell colour (fill) based on the value of 2 other cells and cleary incorrectly using a nested if!
Can anyone correct the below?
So A10 must be an Empty Cell & C11 must have a number in in greater than zero
=IF(AND(A10="", C11>"0"))
Thanks!
Trying to format a cell colour (fill) based on the value of 2 other cells and cleary incorrectly using a nested if!
Can anyone correct the below?
So A10 must be an Empty Cell & C11 must have a number in in greater than zero
=IF(AND(A10="", C11>"0"))
Thanks!