Hi ExcelGURUs,

I have a spreadsheet where lots of conditional formatting are required.
I want to do it using formula or VB code. For example in A column I have both number and text value (each value is coming from a vlookup formula from a diff tab of the same spreadsheet). I want to highlight only the numbers with a different colour.

If anyone can help me with this….I can try the other requirements.