If the format will be the same for all the cells, i.e., all red when 100,
then simply select all the cells in question, and the cell with the focus
(colored white in selection) should be the cell of reference in the
conditional formula.

For example, select A1:A100.
A1 is white, and the other cells are black.

then <Format <Conditional Format
Click "Formula Is", and enter this formula:
=A1100
Click "Format", and choose your format choices.
Then <OK <OK

All the cells that were in the selection will now have the same conditional
format as A1.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"smith.james0"
wrote in message
news:smith.james0.1r94yb_1119819901.8423@excelforu m-nospam.com...

How do i conditional format a large amount of cells? I need each cell to
change colour when a certain value is inputted into that cell.


--
smith.james0
------------------------------------------------------------------------
smith.james0's Profile:
http://www.excelforum.com/member.php...o&userid=16230
View this thread: http://www.excelforum.com/showthread...hreadid=382344