Use the condition

Formula Is =AND(A1<"",d1="")
Pick some formatting

in Cell D1.

If you make sure that there are no absolute indicators (ie. $A$1) you can
use the format painter to copy this format to the other cells
"alarson01" wrote:

I want to apply conditional formatting to cells that are blank depending on
if other cells have text or numbers in them. For example:

If cells A1:A5 have text or numbers in them than cells D1:D5 must have
something in them. If they do not, then whatever cells in the range D1:D5
are blank, apply formatting.

Clear as mud? Thank you much!!
--
-A