rshetty_79
New Member
Hi,
I am trying to create an IF function statement combining it with conditional formatting.
My question is in 2 folds:
1.
The formula that I am trying to create is
If B2 = 'New'
- check B3 = '0' (i.e.blank), if false then colour B3 with Red AND
- check B4 = 'Tester', if false then colour Red.
If you can help me with this thing, then I can go ahead and figure out for other such conditions that I have.
2.
I have a table which gives me rules like the above one and I want to apply these rules on a worksheet which has all these data. Then how do I go about ensuring that I can do this. Is there a workaround without creating macro?
Thanks
I am trying to create an IF function statement combining it with conditional formatting.
My question is in 2 folds:
1.
The formula that I am trying to create is
If B2 = 'New'
- check B3 = '0' (i.e.blank), if false then colour B3 with Red AND
- check B4 = 'Tester', if false then colour Red.
If you can help me with this thing, then I can go ahead and figure out for other such conditions that I have.
2.
I have a table which gives me rules like the above one and I want to apply these rules on a worksheet which has all these data. Then how do I go about ensuring that I can do this. Is there a workaround without creating macro?
Thanks
