Prev: I know this is obvious but ..
Next: Lookup changing data range in external workbook
From: Flojoe on 9 Mar 2010 08:27
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 9 Mar 2010 10:48
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

 | 
Pages: 1
Prev: I know this is obvious but ..
Next: Lookup changing data range in external workbook