Advanced Conditional Formatting

To highlight F2 only if A2:E2 contain entries, Condition 1 Formula is:

=AND(ISBLANK(F2),COUNTA(A2:E2)=COLUMNS(A2:E2))

Thanks Andrew Poulsom works beautifully

Ooops Andrew a slight problemo

Slight problem with this code


------------------------------------------------------------
------------------------------------------------------------
In my tracker

Cloumn position

A--------------BCDE-----------------------------------N
Name------Auto Date (always has some data)---------Priority

-----------------------------------------------------------
-----------------------------------------------------------

When the Name is selcted from the drop down menu the Date and Time are auto insterted due to a macro (they are further refrenced to cell D & E to protect B & C which is hidden) The Priority Column is Placed at "N" and the Name Column is at "A"

So all that I want is the formula to check if there is any data in Column A " Name field" and if there is data there and no data in column "N" Priority then the Priority cell should be highlighted

The formulas should not take B,C,D&E into consideration since there is always some data there.

I did try few changes here and there in the formula but nothing worked.

Can you please check this and if possible advise me how the formula parameter works so that I could understand how the formula worksl.

In Brief

Cloumn position

A BCDE N
Name Auto Date (always has some data) Priority



I have updated the sample in the Cross post site

Forgot to mention why I need the formula to check only the first column for data.

Since Column B/C/D/E has some data always then the present formula results in an error wherein the Column “N” Priority goes RED through out – just as if using the Conditional Formatting without the formula – so we are back to square one.

I found this problem when I tested it in the real tracker in terms of column positions which is closer to the latest on attached in Joseph’s Excel forum.

Did you try?

=AND(ISBLANK(F2),LEN(A2)=0)

Nope that is not working however this one is working fine

=AND($A2<>"",$N2="")