Conditional Formatting

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.

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:
=A1>100
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" <smith.james0.1r94yb_1119819901.8423@excelforum-nospam.com>
wrote in message
news:smith.james0.1r94yb_1119819901.8423@excelforum-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
>