This article covers conditional formatting in the context of Excel JavaScript add-ins. The following articles provide detailed information about the full conditional formatting capabilities within Excel. Add, change, or clear conditional formats; Use formulas with conditional formatting. In Excel, use formulas in conditional formatting to do more than you can with the built-in rules. For example, format blank cells, or see which salespeople are selling above average, or track who has received birthday greetings from you. How to Apply Conditional Formatting in Excel. This wikiHow teaches you how to add conditional formatting to a Microsoft Excel spreadsheet on both Windows and Mac computers. Conditional formatting will highlight cells that contain data.
Hi Thenga,
My name is Eric, I have read whole thread carefully and I want to share with you my idea.
Because in column D, we need do conditional formatting base on a formula, Based on formula is more complex then base on a value in the cell for Excel, at present, We can't set three color base on formula at once but set them one by one.
I know you want to optimize the calculation, because 3-color format style only judge by checking the list one time while the three formulas will check the list three times. A s far as I known, it won't cause delay unless you have a huge database, I always assign more than ten formula format in one sheet and the function works well.
Additional, it is possible to use VBA to achieve our goal, because we can link the color of different cells by the Macros (for example link C1 to A1):
Private
Sub
Worksheet_SelectionChange(
ByVal
Target
As
Range)
Me
.Range(
'C1'
).Interior.Color =
Me
.Range(
'A1'
).Interior.Color
End
Sub
If you are interest in it, you can post a new thread in Programming category to get further help about linking color of two different columns.
Set Conditional Formatting Microsoft Excel
Regards,
Eric
Microsoft Excel Conditional Formatting If Statement
Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.