Finite difference method FDM

tjjeannette

New Member
Joined
Oct 10, 2002
Messages
2
I am doing a FDM project for a heat transfer class and I wanted to add a little something extra to my excel spreadsheet. I want excel to change the color of an individual cell based on the value in that cell. The values will be temperatures, so with the color change I will get a graphical representation of the temperature at each point in my table. Does any one know how to do such a thing?

Thanks
TJ
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Is sounds like you may want to look at conditional formatting....quite easy actually

Format | Conditioal formatting


there are a lot of examples to be found in the search section of this site...

hope this helps

pll
 

tjjeannette

New Member
Joined
Oct 10, 2002
Messages
2
Thanks for that advice. I wanted to add more than three conditions to the data so I can get wider range of colors. Any other options?
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Probably in VBA code, you can do wonderful things....i leave this question open for the code writers....you may want to show a short example and your expected outcome so thay may have something to work with...it usually goes a little faster..

good luck
 

Forum statistics

Threads
1,144,149
Messages
5,722,794
Members
422,459
Latest member
Chriselff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top