| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing background colour when changing data in a cell
I want a cell to change its colour to green when another cell has yes in itl.
If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing background colour when changing data in a cell
formatconditional formatetc
-- Don Guillett Microsoft MVP Excel SalesAid Software "Paoul" wrote in message ... I want a cell to change its colour to green when another cell has yes in itl. If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing background colour when changing data in a cell
use Format/Conditional Formatting
"Paoul" wrote: I want a cell to change its colour to green when another cell has yes in itl. If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing background colour when changing data in a cell
Hi Paoul,
What you're talking about is called in excel "conditional formatting" . You can find here some tutorials for getting started with using it: http://www.free-training-tutorial.co...ormatting.html -- "Paoul" wrote: I want a cell to change its colour to green when another cell has yes in itl. If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing background colour when changing data in a cell
I can do it for same cells but i cant seem to find a way to do it so it
changes a different cell. The rules in the conditional formatting seems to be stuck to particular cells "Paoul" wrote: I want a cell to change its colour to green when another cell has yes in itl. If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing background colour when changing data in a cell
Look out for $ signs in the CFFormula is:
Excel tries to help and places absolute references like $A$1 when you may want $A1 or A1 for copying to other cells. Gord Dibben MS Excel MVP On Tue, 23 Dec 2008 08:49:01 -0800, Paoul wrote: I can do it for same cells but i cant seem to find a way to do it so it changes a different cell. The rules in the conditional formatting seems to be stuck to particular cells "Paoul" wrote: I want a cell to change its colour to green when another cell has yes in itl. If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing background colour when changing data in a cell
Suppose your values are in Column A. Select column B go to conditional
formattin..choose "formula is" and type =$a2="YES" and click on format and change the color of cell to green. Add condition 2...chosse "Formula is" and type =$a2<"YES" go the format and change the cell color into red.. it will work. "Paoul" wrote: I can do it for same cells but i cant seem to find a way to do it so it changes a different cell. The rules in the conditional formatting seems to be stuck to particular cells "Paoul" wrote: I want a cell to change its colour to green when another cell has yes in itl. If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing background colour when changing data in a cell
Suppose your value is in column A. Then select column B and go to conditional
formattting. Condition 1: select "Formula Is" and type =$a2="YES". Click on Format button and change the color into green. Condition 2: select "Formula Is" and type = $a2<"YES". Click on Format button and change the color into Red. This works "Paoul" wrote: I want a cell to change its colour to green when another cell has yes in itl. If it does not have yes in it i want it to be red. Ive tried using the iF function but i dont know how it works and i keeep getting errors Help is appreciated :) Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing default chart settings like background colour etc | Setting up and Configuration of Excel | |||
| Permanently changing default chart settings like gridlines and background colour | Charts and Charting in Excel | |||
| changing cell background color | Excel Worksheet Functions | |||
| Changing background color based on different cell | Excel Discussion (Misc queries) | |||
| changing background colour in VB editor | Excel Discussion (Misc queries) | |||
Linear Mode
