<div>
Note:<br />
<br />
I used &quot;Issue_Sent&quot; in my post.<br />
<br />
Your post has &quot;Issue_Sant&quot; (so you may need to correct my field name)
</div>


Note:

I used "Issue_Sent" in my post.

Your post has "Issue_Sant" (so you may need to correct my field name)

<div>
Mbizup, thanks for the response. &nbsp; Do I need to use control source names?
</div>


Mbizup, thanks for the response.   Do I need to use control source names?

<div>
I got it. &nbsp;It is not the control names...just the field names. &nbsp;<br />
<br />
It works! &nbsp;thank you!!
</div>


I got it.  It is not the control names...just the field names.  

It works!  thank you!!

<div>
Good question!<br />
<br />
Offhand - For CF, I beleive you need the field names (control sources) versus the textbox names.<br />
<br />
(If that doesn't work out, switch to using textbox names...)<br />
<br />
I'm going to double check myself to verify...
</div>


Good question!

Offhand - For CF, I beleive you need the field names (control sources) versus the textbox names.

(If that doesn't work out, switch to using textbox names...)

I'm going to double check myself to verify...

<div>
Haha! &nbsp;I thought so... but couldn't quite remember &nbsp;(I don't recommend getting old). &nbsp;I don't use CF much.<br />
<br />
Glad you've got it sorted...
</div>


Haha!  I thought so... but couldn't quite remember  (I don't recommend getting old).  I don't use CF much.

Glad you've got it sorted...

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have a form in split mode with datasheet on bottom.<br />
I am trying to use conditional formatting to color the column [Issue_CSM] if it does not equal either of the other 2 columns. &nbsp;<br />
Some cells are null though. <br />
<br />
Any ideas? &nbsp;thank you<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/05_w21/577754/untitled.JPG" target="_blank" title="ConditionalFormatting (10 KB)"><img alt="ConditionalFormatting" class="file-block lazyload" style="max-width: 348px;" data-src="https://filedb.experts-exchange.com/incoming/2012/05_w21/577754/untitled.JPG" /></a>
</div>
</div>


untitled.JPG

Experts,

I have a form in split mode with datasheet on bottom.
I am trying to use conditional formatting to color the column [Issue_CSM] if it does not equal either of the other 2 columns.  
Some cells are null though. 

Any ideas?  thank you




Conditional Formatting

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.