<div>
If the controls support the Conditional formatting you just copy paste the Conditional Format rule...or your could implement it via VBA ( a bit complex)
</div>


If the controls support the Conditional formatting you just copy paste the Conditional Format rule...or your could implement it via VBA ( a bit complex)

Database Developer

LillyC

<div>
you're welcome, Lilly ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
Is it possible to apply conditional formatting to a complete row containing several fields, if I just set the rule in the first field?<br />
<br />
E.g. - I have applied the rule to the company name so each company has a specific colour, but I would like all the fields in that row to have the same colour<br />
<br />
Company &nbsp; &nbsp; Description &nbsp; &nbsp; &nbsp;Client &nbsp; &nbsp; Job Number &nbsp; Etc<br />
Company &nbsp; &nbsp; Description &nbsp; &nbsp; &nbsp;Client &nbsp; &nbsp; Job Number &nbsp; Etc<br />
Company &nbsp; &nbsp; Description &nbsp; &nbsp; &nbsp;Client &nbsp; &nbsp; Job Number &nbsp; Etc<br />
Company &nbsp; &nbsp; Description &nbsp; &nbsp; &nbsp;Client &nbsp; &nbsp; Job Number &nbsp; Etc
</div>
</div>


Is it possible to apply conditional formatting to a complete row containing several fields, if I just set the rule in the first field?

E.g. - I have applied the rule to the company name so each company has a specific colour, but I would like all the fields in that row to have the same colour

Company     Description      Client     Job Number   Etc
Company     Description      Client     Job Number   Etc
Company     Description      Client     Job Number   Etc
Company     Description      Client     Job Number   Etc

Conditional Formatting in a report in MS Access

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.