Use if statement with conditional formatting?

Is it possible to use an IF statement within the conditional formatting
dialog? If so, I have not been able to figure out how to do it. Can
someone point me to an example?

Thanks.

Select A1.

Format|conditional formatting
formula is: =if(a1>10,true,false)

But you just need the portion that evaluates to true or false:
formula is: =a1>10

would work (and would be more common).



q5 wrote:
>
> Is it possible to use an IF statement within the conditional formatting
> dialog? If so, I have not been able to figure out how to do it. Can
> someone point me to an example?
>
> Thanks.

--

Dave Peterson

I guess I was trying to make it all too complicated!

Thanks for the help.


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Select A1.
>
> Format|conditional formatting
> formula is: =if(a1>10,true,false)
>
> But you just need the portion that evaluates to true or false:
> formula is: =a1>10
>
> would work (and would be more common).
>
>
>
> q5 wrote:
> >
> > Is it possible to use an IF statement within the conditional formatting
> > dialog? If so, I have not been able to figure out how to do it. Can
> > someone point me to an example?
> >
> > Thanks.
>
> --
>
> Dave Peterson