Formatting Formula Results

[Guest]

Is it possible to format a cell based on the results of a conditional value? For example, if the results is less than 2.0, shade the cell a predefined color. Thanks

 

[Ken Wright]

Format / Conditional Formatting - Choose your criteria and then choose the
colours of the font or pattern to be displayed when the criteria is met.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all
----------------------------------------------------------------------------

Is it possible to format a cell based on the results of a conditional value?

For example, if the results is less than 2.0, shade the cell a predefined color.
Thanks

 

[Andy B]

Hi

Have a look at Format / Conditional Formatting. This will do it for you.

Andy.

Is it possible to format a cell based on the results of a conditional

value? For example, if the results is less than 2.0, shade the cell a
predefined color. Thanks

 

[Norman Harker]

Hi "shroomtune"

Select the cell
Format > Conditional Format
In second drop down select "Less than"
In the third drop down put 2]
Press Format
Pattern tab
Select the color
OK
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Is it possible to format a cell based on the results of a

conditional value? For example, if the results is less than 2.0,
shade the cell a predefined color. Thanks