| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i change cell colour by value in excell
I am trying to varie the colour of a cell depending on the returned value of
that cell. The cell has a few simple sums within it culd anybody help with a very inexperianced user Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i change cell colour by value in excell
Hi,
You can use conditional formating, let's say your cell whit the formula is in A1 and the cell you want to change color in A2, if the result you are looking for is if that value is greater than 1 enter position yourself on Cell A2 and in conditional formating enter A11, then choose the color "Kram" wrote: I am trying to varie the colour of a cell depending on the returned value of that cell. The cell has a few simple sums within it culd anybody help with a very inexperianced user Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i change cell colour by value in excell
Maybe this site will help you understand how it works.
http://office.microsoft.com/en-us/ex...CL100570551033 "Kram" wrote: I am trying to varie the colour of a cell depending on the returned value of that cell. The cell has a few simple sums within it culd anybody help with a very inexperianced user Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell colour on formula result change, no conditional format | Excel Programming | |||
| if cell colour is then change cell colour in range | Excel Programming | |||
| Excell and changing cell colour | Excel Programming | |||
| Change colour of cell if there is no value | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Linear Mode
