changing color of answer

  • Thread starter Thread starter gman1964
  • Start date Start date
G

gman1964

I'm trying to change the color of my result to a different color based on
which answer a formula brings back. all my answers are in text format. The
formula is below which is just a simple vlookup data proving type.

=IF(ISERROR(IF(C7="DDG",VLOOKUP(B7,'DDG
Cars'!$A$2:$B$152,2,FALSE),VLOOKUP(B7,'Ethanol
Cars'!$A$3:$C$499,3,FALSE)))=TRUE,"",(IF(C7="DDG",VLOOKUP(B7,'DDG
Cars'!$A$2:$B$152,2,FALSE),VLOOKUP(B7,'Ethanol Cars'!$A$3:$C$499,3,FALSE))))
 
You can use Conditional Formatting, but you are limited to 3 Conditions (as
far as I know). If you have 3 or less answers this would be the easy way.
Highlight cells, click on Format, Conditional Foramtting, 1st box should say
"Cell Value Is" 2nd box should be set to "equal to", and the 3rd box type in
your criteria. Click on the Format box and select the tab of what you to
"color", If you want the font to change color click on the font tab and pick
your color, or the shading to change, click on Patterns and pick color.
Click "OK" when finished
 

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

Back
Top