How to show a cell/data separately if the number goes below a specified level.?

Dear Frnds,

I have entered a formula in a cell which changes its figures(in numbers) automatically.

There are around 70 cells in that workbook, whose numbers increases or decreases automatically.

I want to show all those cells or headings whose value goes below a specified level.

example. Suppose there are 20 cells from A1 to T1. Each cell has some addition or subtraction formula in it. When ever any number in those cell goes below 500 then it should appear separately.
So that the user without going through all the cells come to know that this cell number is below the specified limit.


I hope I am able to make my question / problem clear to you people.

Kindly give me the solution to this.

I will be thank ful to you.

[email protected]

conditional formatting allows a cell colour, border, font etc to be displayed in 4 different colours according to value

eg if negative, red
if 0 to 5 yellow
if 6 to 8 orange
if 9 or above red

would this automatic highlighting of cells help?