Conditional Formatting.

If the result of my formula in A1 is 5
And my Conditional Format for A1 is configured as:
Cell Value Is greater than 3
Colour Red

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"keith24 " wrote in message
...
If I have an answer to an argument that exceeds a certain number then I
want the cell to be colour flagged red as a warning so that it will
instantly stand out in a large sheet of data. Any ideas


---
Message posted from http://www.ExcelForum.com/