Formatting according to source data.

M

Mike

Use conditional formating. What ever you are using in
your formula to determine which book to pull data from can
also be used to determine a conditional format. Lets say
your formula is something like:

=IF(A1=1,{PullDataFromFileA},{PullDataFromFileB})

Click the cell and set the font to blue. Then select
Format from the menu, click Conditional Formatting. In
the first drop down list, select Formula Is, enter A1=1 in
the text box, click the format button, select the colour
red, click OK. Now if A1=1, then the conditional format
overrides the default colour you have set.
 

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 in range 1
Data Validation/Conditional Formating 3
[Flashing] RED before renewal date 1
Conditional Formatting 4
My conditional formatting evaluates only when I double click cells 0
Conditional formatting in a formula 1
Coditional Format 4
Format Painter in Excel 2007 4

Top