Conditionally Format row if formula in cell returns a date

[SaraWitch]

Hi peeps,

I have a formula in A1 that picks up a date from a range of other cells. If there are no dates in the range, A1 remains blank. I want to conditionally format the row colour when that formula returns a date but remain as is if blank.

Before the formula, I was using a conditional format rule:

=$A1>0

and changing the row colour. However, with the formula now in A1, the row is changing colour regardless of whether there is an actual date or if the cell is blank.

I have also tried

=$AE8("format",$AE8)="D4"

but this is not working either (my date format is dd/mm/yyyy and I cannot find the date code for this, but I have changed the cell format to dd/mm/yy and it makes no difference).

Any help would be appreciated...

 

[awoohaw]

Maybe try this:
(This will not work if you formula returns text, but you could make the CF test an AND function:

=AND($A1<>"",IsNumber($A1))

or maybe just

=ISNUMBER($A1)

Mr Excel Questions 72.xlsm
	A	B	C	D	E	F
1	2023-01-01	TRUE	=DATE(2023,1,1)
2	dfasd	TRUE	="dfasd"
3		FALSE	=""
4	2023-01-01	TRUE	=DATE(2023,1,1)
5
6
7
8
9
10
Sheet5

Cell Formulas
Range	Formula
A1,A4	A1	=DATE(2023,1,1)
B1:B4	B1	=A1<>""
C1:C4	C1	=FORMULATEXT(A1)
A2	A2	="dfasd"
A3	A3	=""

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:D11	Expression	=$A1<>""	text	NO

 

[SaraWitch]

Thank you, @awoohaw. ISNUMBER($A1) works perfectly!