Workday Func and conditional formatting

N

Nick

Is it possible to use the WORKDAY function inconjunction
with TODAY(), a number and a date in a conditional format.

The following line in an IF statement works fine:-

=IF(WORKDAY(TODAY(),A20)>B20,"TOO MUCH WORK","") where
A20= a number and B20 = a date.

But when I try the following:-

=WORKDAY(TODAY(),A20)>B20 I get a message stating cannot
reference to other worksheets or workbooks when using CF -
which I am not!

Any help much appriciated.

ps - aware can work around it using hidden columns but
this is not really ideal.

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting - workdays only 10
Using workday function to populate schedule 2
Conditional Formatting with Dates 2
Conditional Formatting Conundrum 3
Count of Font Format 1
Date Conditional Formatting 4
Conditional Formatting - Cannot get it to work, please help 1
Conditional Formatting Less Than Today Week Days only 0

Top