how to automatically color a cell

can i do that? my requirement is, based on a criteria (IF), if the criteria
is true then color the cell with color (any color)

Example: IF(A4=A5,red_color,no_fill)

if color code is required in this, pls do help to let me know how to get the
color code too...

billion thanks to expert out there

Hi
Have a look at Format|Conditional Formatting. Look here for an intro:
http://www.cpearson.com/excel/cformatting.htm

--
Andy.


"jacko" <[email protected]> wrote in message
news:[email protected]...
> can i do that? my requirement is, based on a criteria (IF), if the
> criteria
> is true then color the cell with color (any color)
>
> Example: IF(A4=A5,red_color,no_fill)
>
> if color code is required in this, pls do help to let me know how to get
> the
> color code too...
>
> billion thanks to expert out there

Check conditional formating in help

<format><Conditional formating>
formula is A4=A5
and set format how you want it.

"jacko" wrote:

> can i do that? my requirement is, based on a criteria (IF), if the criteria
> is true then color the cell with color (any color)
>
> Example: IF(A4=A5,red_color,no_fill)
>
> if color code is required in this, pls do help to let me know how to get the
> color code too...
>
> billion thanks to expert out there

billion thanks!!

"Andy B" wrote:

> Hi
> Have a look at Format|Conditional Formatting. Look here for an intro:
> http://www.cpearson.com/excel/cformatting.htm
>
> --
> Andy.
>
>
> "jacko" <[email protected]> wrote in message
> news:[email protected]...
> > can i do that? my requirement is, based on a criteria (IF), if the
> > criteria
> > is true then color the cell with color (any color)
> >
> > Example: IF(A4=A5,red_color,no_fill)
> >
> > if color code is required in this, pls do help to let me know how to get
> > the
> > color code too...
> >
> > billion thanks to expert out there
>
>
>