how do i change cell colour by value in excell

  • Thread starter Thread starter Kram
  • Start date Start date
K

Kram

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
 
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 A1>1, then choose the color
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can i change colour of a cell 2
Cell colour format according to date 1
Changing font colour for cell variables 3
function to re-calculate when cell format (colour) changes 1
Conditional formatting with vba 3
Colour a row, based on a cell value 8
Count Conditional Formatting Colours - Excel 2003 4
Microsoft Excel VBA: Concatenate without formatting 1

Back
Top