Conditional Formatting on 2 conditions

[oblah]

Hi all,

I want to a cell to change colour dependant on 2 conditions.

Logic:

If
H3 is 'No'

AND
J3 is blank

Then
J3 is Red

Else
J3 is white.


I want this to be conditionally formatting, as the user is to write in the red box thus the box returning to white once text has been inputted.

Many thanks

[sweep]

Hi,

Select cell J3,

Use normal cell formatting to set the fill to white, then use this formula to activate the red fill

Please Login or Register  to view this content.

[oblah]

Much Appreciated Sweep!!

I attempted something very similar (it seems like overkill compared to yours + it didn't work)

I tried used IF in conjunction with AND.

Just out of curiosity, would IF(AND work in this instance?

Thanks again

[JeteMc]

You could write an IF(AND... formula however that would be overkill as you mention.
The formula would probably read: =IF(AND(H3="No",J3=""),TRUE,FALSE) which would evaluate to either TRUE or FALSE the same as =AND(H3="No",J3="") does.
Let us know if you have any questions.