I would like to use Excel's conditinal formatting of a particular column based on values in two other columns.
- I have values in columns A, B, C and D.
- column A has text values (any value user enters)
- column B has a numeric value (any value user enters)
- column C has a text value selected from a set of values (data validation using drop-down):
column D is defined as (x stands for any row number)
user can as well delete the formula in column D thus making it empty
I want values in column A displayed in red when D is empty and user didn't select
End in column C. So this only happens when a user deletes the formula in D.
So I thought of creating a conditional formatting rule that would do the trick for me. But when I try to write the condition formula it doesn't work.
I've tried specifying this formula for conditional formatting rule:
but it didn't work.
Are there any limitations which functions can be used in this formula, because when I use something like
AND() it seems it simply stops working even though they're simple boolean functions that return