Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - value of one cell greater than another cell
How do I set up a conditional format for a cell that I want to change once
the value becomes greater than the value of another cell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - value of one cell greater than another cell
Imagine you want to change the format of A2 depending on the value in
B2. Select cell A2 and click on Format | Conditional Formatting, and in the pop-up you should choose Formula Is rather than cell Value Is in the first box. Then in the next box you can enter this formula: =A2B2 Click on the Format button and then choose the Patterns tab (for background colour) and choose a colour. Click OK twice to exit the dialogue box. Now if A2 is larger than B2 the background colour will change. If A2 is not larger than B2 then the background colour will revert to normal. Hope this helps. Pete On Nov 7, 12:09*am, Ken Starlin wrote: How do I set up a conditional format for a cell that I want to change once the value becomes greater than the value of another cell |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - value of one cell greater than another ce
That's how I used to do it in Excel 2003, but I'm not sure how to get there
in Excel 2007. I can't find the pop up to change from "formula is" to "cell value" is. "Pete_UK" wrote: Imagine you want to change the format of A2 depending on the value in B2. Select cell A2 and click on Format | Conditional Formatting, and in the pop-up you should choose Formula Is rather than cell Value Is in the first box. Then in the next box you can enter this formula: =A2B2 Click on the Format button and then choose the Patterns tab (for background colour) and choose a colour. Click OK twice to exit the dialogue box. Now if A2 is larger than B2 the background colour will change. If A2 is not larger than B2 then the background colour will revert to normal. Hope this helps. Pete On Nov 7, 12:09 am, Ken Starlin wrote: How do I set up a conditional format for a cell that I want to change once the value becomes greater than the value of another cell |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - value of one cell greater than another ce
I'm sorry, Ken, I don't have XL2007, so I can't help you there.
Perhaps someone else will chip in ... ? Pete On Nov 7, 12:43*am, Ken Starlin wrote: That's how I used to do it in Excel 2003, but I'm not sure how to get there in Excel 2007. I can't find the pop up to change from "formula is" to "cell value" is. "Pete_UK" wrote: Imagine you want to change the format of A2 depending on the value in B2. Select cell A2 and click on Format | Conditional Formatting, and in the pop-up you should choose Formula Is rather than cell Value Is in the first box. Then in the next box you can enter this formula: =A2B2 Click on the Format button and then choose the Patterns tab (for background colour) and choose a colour. Click OK twice to exit the dialogue box. Now if A2 is larger than B2 the background colour will change. If A2 is not larger than B2 then the background colour will revert to normal. Hope this helps. Pete On Nov 7, 12:09 am, Ken Starlin wrote: How do I set up a conditional format for a cell that I want to change once the value becomes greater than the value of another cell- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - value of one cell greater than another ce
Try this:
HomeConditional FormattingNew Rule...Use a formula to determine which cells to formatEnter formulaSet format Regards, Fred. "Pete_UK" wrote in message ... I'm sorry, Ken, I don't have XL2007, so I can't help you there. Perhaps someone else will chip in ... ? Pete On Nov 7, 12:43 am, Ken Starlin wrote: That's how I used to do it in Excel 2003, but I'm not sure how to get there in Excel 2007. I can't find the pop up to change from "formula is" to "cell value" is. "Pete_UK" wrote: Imagine you want to change the format of A2 depending on the value in B2. Select cell A2 and click on Format | Conditional Formatting, and in the pop-up you should choose Formula Is rather than cell Value Is in the first box. Then in the next box you can enter this formula: =A2B2 Click on the Format button and then choose the Patterns tab (for background colour) and choose a colour. Click OK twice to exit the dialogue box. Now if A2 is larger than B2 the background colour will change. If A2 is not larger than B2 then the background colour will revert to normal. Hope this helps. Pete On Nov 7, 12:09 am, Ken Starlin wrote: How do I set up a conditional format for a cell that I want to change once the value becomes greater than the value of another cell- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format - value of one cell greater than another cell
Or you can leave it as Cell Value Is, & select "greater than", and =B2
-- David Biddulph "Pete_UK" wrote in message ... Imagine you want to change the format of A2 depending on the value in B2. Select cell A2 and click on Format | Conditional Formatting, and in the pop-up you should choose Formula Is rather than cell Value Is in the first box. Then in the next box you can enter this formula: =A2B2 Click on the Format button and then choose the Patterns tab (for background colour) and choose a colour. Click OK twice to exit the dialogue box. Now if A2 is larger than B2 the background colour will change. If A2 is not larger than B2 then the background colour will revert to normal. Hope this helps. Pete On Nov 7, 12:09 am, Ken Starlin wrote: How do I set up a conditional format for a cell that I want to change once the value becomes greater than the value of another cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colors and conditional format - greater than, less than | Excel Discussion (Misc queries) | |||
conditional format if cell contains the text IQ anywhere in cell | Excel Discussion (Misc queries) | |||
conditional format if cell contains link to another cell | Excel Discussion (Misc queries) | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
conditional format greater or less than | Excel Discussion (Misc queries) |