Excel 2000: Conditional Formatting when DGET Function returns #VALUE! 1

[LINSEY]

I have set up a form that uses DGET functions to pull data from a spreadsheet. If the cell on the spreadsheet does not contain data, the DGET function returns "#VALUE!".

I would like to use conditional formatting to change the font color to white on cells that contain "#VALUE!".

I have tried:

cell value is = #VALUE!
cell value is = "#VALUE!"
cell value is = 0
cell value is = "0"
formula is = #VALUE!
formula is = "#VALUE!"
formula is = DGET(STYLE,"CUSTOMER",CRIT)=#VALUE!
formula is = DGET(STYLE,"CUSTOMER",CRIT)="#VALUE!"
formula is = DGET(STYLE,"CUSTOMER",CRIT)=0
formula is = DGET(STYLE,"CUSTOMER",CRIT)="0"
formula is = DGET(STYLE,"CUSTOMER",CRIT)=FALSE
formula is = DGET(STYLE,"CUSTOMER",CRIT)="FALSE"

None of these formats works.

Can anyone help or is this impossible?

Linsey

 

[DaleWatson123321]

LINSEY,

I've tested this, and it works... (It doesn't use Conditional Formatting.)

=IF(ISERROR(DGET(STYLE,"CUSTOMER",crit)),"",DGET(STYLE,"CUSTOMER",crit))

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[LINSEY]

Thanks again Dale! I had tried using an IF function, but I was not using the ISERROR function.

 

[goopit]

You're question is similar to the one I have, Linsey. I have a file using the LOOKUP function and I'd tried to use conditional formatting to make the cells with #N/A have white fonts.

I don't understand where Dale's fix is supposed to be placed. In the same cell where I've got my LOOKUP function =LOOKUP(B2, AS2:AT1897? In an adjacent column?

It's probably an easy fix, but I'm just not getting it. Any help will be most appreciated.

Thank You,
goopit

 

[mbarron]

Dale answer would be in a cell on the sheet. To use the formula in conditional formatting, Dales formula would be changed to:

=IF(ISERROR(DGET(STYLE,"CUSTOMER",crit)),TRUE,FALSE)



Mike