Change cell color not using conditional formatting

[datamster]

Hi all,

Is it possible to use a function (if statement or an array?) to change the color of a cell without using conditional formatting. I don't want to use conditional formatting because the workbook is already full of formulas and takes a fair amount of time to update. Thank you.

 

[Jonmo1]

The only formula way is with conditional formatting.

You could use some VBA macro code to do it.
Can you get more specific about which cells need to change to which colors based on what criteria?

 

[datamster]

More specifically I have a list of names and a color assigned to each name, then have rows of data that correlates to a name. The data is pulled from a database and has a macro to auto-run. I don't have confidence in conditional formatting to do this unmonitored.

 

[datamster]

Here is a simple formula of where I'm going with this. =IF(Z12="American Airlines","[Green]",""). Obviously this just shows the word green. In format cells [] are used to turn negative numbers red. What is the syntax to turn the cell green from within the IF formula, or is there a better formula to use. Thank you for any help on this.

 

[Jonmo1]

Other than that little trick turning negative numbers green with custom formatting
Conditional formatting is the only way to apply formats to cells based on a formula result.


You'd have to use VBA

Sub Test
If Range("Z12").Value = "American Airlines" Then
    Range("Z12").Interior.Color = vbgreen
End If
End Sub

 

[datamster]

I'll take the VBA approach, thanks for the help Jonmo1