From: Flojoe on
HELP! I cannot get your steps to work with Microsoft Office Excel 7 -- when
I go to Data there is not a Conditional Formatting option to select from --
what am I missing? Thanks! Flojoe

"bpeltzer" wrote:

> Use conditional formatting. Select the cell, then Data > Conditional
> Formatting. Set the condition(s) and corresponding format(s). Then if the
> condition is satisfied the format will be applied.
>
> "donschap" wrote:
>
> > I'm trying to change the fill color of a cell based on a condition (value)..
> > FOr example if a value is less than 7, fill the cell color in red
From: Fred Smith on
There is no Excel version 7. Do you mean Excel 2007?

If so, Conditional Formatting is on the Home menu.

Regards,
Fred

"Flojoe" <Flojoe(a)discussions.microsoft.com> wrote in message
news:6BB576B8-85C6-4889-AC09-7598B552B46F(a)microsoft.com...
> HELP! I cannot get your steps to work with Microsoft Office Excel 7 --
> when
> I go to Data there is not a Conditional Formatting option to select
> from --
> what am I missing? Thanks! Flojoe
>
> "bpeltzer" wrote:
>
>> Use conditional formatting. Select the cell, then Data > Conditional
>> Formatting. Set the condition(s) and corresponding format(s). Then if
>> the
>> condition is satisfied the format will be applied.
>>
>> "donschap" wrote:
>>
>> > I'm trying to change the fill color of a cell based on a condition
>> > (value)..
>> > FOr example if a value is less than 7, fill the cell color in red