Change fill of active cell to a more noticeable color using conditional formatting only

Change the fill of the active cell to a more noticeable color using conditional formatting only, no VBA required.

NOTE: Uploaded file with examples (=EG)

The reference for these formulas is on the Tushar Mehta site. The examples in the tutorial weren't exactly what I wanted, so I created 2 sets of conditional formatting formulas by modifying the examples. I don't understand how these formulas work, so I used the 'try & try until it works' method. Do Not Ask Me How These Work!

The 1st conditional formatting formula highlights only the active cell (when the active cell is in the area defined by the conditional format). Any fill color, font and font color can be used. My preference is for a stark black fill with a white font.

2nd is a set of 4 conditional formatting formulas that highlight the row & column of the active cell, but NOT the active cell itself (when the active cell is in the area defined by the conditional format). This places the active cell in the cross-hairs of a highlighted column & a highlighted row. In a large data grid, the cross-hairs make it easier to find the active cell.

All 4 formulas are required to highlight the row & column of the active cell. The 1st highlights the row to the left of the active cell; the 2nd, the row to the right; the 3rd, the column above; and the 4th, the column below. There are probably better ways to skin this cat, so if you figure that out, please post it.

I don't see any conditional formats in the example you provided.

can u pls show us how this works?

That is interesting, I do have to select the entire range first c8:Q14, then when I select a cell inside that range it changes color, same as E40:P54

Thanks for sharing!

Ah I see, F9 does the trick. I put this code in the worksheet module

Please Login or Register  to view this content.

Then it works automatically, course then there are other issues.

Pressing F9 calculates the sheet, selecting a range will not trigger the conditional formatting because there has been no calculating until something has been entered.