Workday formula on a Conditional Formatting

**Kinna** · 05-29-2009, 01:10 PM

Hello, I am having an issue, because aparently workday formula does not work in conditional formattings.
I have the two formulas below to use in conditional formattings, but I can't figure out how to re-write them so that Excel will allow me.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for helping me before and sorry for posting previously in the wrong topic.

**NBVC** · 05-29-2009, 01:17 PM

Yes ATP functions don't work in Conditional Formatting..

2 options:

Easiest: Put those formulas in a cell within same row (should give TRUE/FALSE) results... then reference that cell in Conditional Formatting.. exammple formula: =$X1=TRUE where X1 holds the results of the formula

Harder: Replace ATP with more complex Excel functions... see here how to replace Workday() function: ATP functions to Excel Functions.

**Kinna** · 05-29-2009, 02:13 PM

I'm trying the easiest one....

So now I have four TRUE/FALSE columns (because I actually have 4 formulas/conditions)

What I am trying to do in the conditional is =AND($IR3="TRUE";$IQ3="TRUE")
I need excel to colour my cell if both are TRUE or if at least one is TRUE, if both are FALSE I don't neet to have it coloured, but this formula only coulours if both are true...

(I have tried =OR($IR3="TRUE";$IQ3="TRUE") as well but it gets coloured all the time...)

**NBVC** · 05-29-2009, 02:15 PM

Use the OR() version but don't put the TRUE in quotes...

e.g.

=OR($IR3=TRUE;$IQ3=TRUE)

**Kinna** · 05-29-2009, 02:58 PM

Wonderful! Thanks a lot!!!

**NBVC** · 05-29-2009, 03:02 PM

No Problem...

Note: You could have also simply used: =OR($IR3;$IQ3) but it is more confusing to understand as a formula... people tend to like the condition spelled out.