highlight cell in formula

how do I make a VBA to search a few times with different highlight color? For example, the first time I search is "AS", then all results with "AS" will be highlighted in yellow. Then the second time, I search is "BD", then all results with "BD" will be highlighted in green. Then the 3rd, I...

I am attempting to automate errors in data using conditional formatting. My intent is to automate highlighting errors when cell data vary. Highlight cell F2 if F2/B2 > 1.5 I've tried several formula variations and cannot get this right. Any formulas that have worked for you?

Building an Excel document for a competition. I have 3 worksheets. Sheet 1 - individual scores in each team with an overall team score. Sheet 2 - Team Score League Table Sheet 3 - Individual Score League Table In Sheet 2 I have ranked teams score (team order - they are numbered 1 - 20) and...

Hi All Excel Guru's, My first post here so please accept my apologies if I am out of line. Question: (Worksheet attached) I have a workbook with two separate Tabs Tab 1 - Floor Plan: Master Warehouse Map with Locations Tab 2 - Damages : List of Damages in the warehouse I have identified...

Normally, when you write a formula, you can see the cell you are referencing highlighted in real time. Excel stopped highlighting active cells when writing formula that spans multiple worksheets. Let me use an extremely simplified example to illustrate my problem: If I type this formula in cell...