Formatting Formula Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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 :-)
----------------------------------------------------------------------------



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

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

Andy.

shroomtune said:
Is it possible to format a cell based on the results of a conditional
Click to expand...
value? For example, if the results is less than 2.0, shade the cell a
predefined color. Thanks
 
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.
shroomtune said:
Is it possible to format a cell based on the results of a
Click to expand...
conditional value? For example, if the results is less than 2.0,
shade the cell a predefined color. Thanks
 
Back
Top