Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight if ...
value in cell in one digit more than cell above. Is this possible?
ex: A 1 3 4 7 4 would be highlighted. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight if ...
Format/ Conditional formatting
If your active cell is A3, then either: Cell value is/ equal to: =A2+1 or Formula is: =A3=A2+1 -- David Biddulph wrote in message ps.com... value in cell in one digit more than cell above. Is this possible? ex: A 1 3 4 7 4 would be highlighted. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight if ...
Highlight the cells from the second one onwards - i.e. from A2 in your
example. Click Format | Conditional Format and in the pop-up select Formula Is rather than Cell Contents and in the next panel enter this formula: A2=A1+1 Click the Format button on the panel, click patterns (background colour) and choose your highlight colour, eg Bright Yellow. Then click OK twice and you should see the number 4 highlighted with bright yellow. Hope this helps. Pete On Jun 28, 9:20 pm, wrote: value in cell in one digit more than cell above. Is this possible? ex: A 1 3 4 7 4 would be highlighted. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight if ...
Select cell A3 that contains the number 4 and select the menu option Format |
Conditional Fomating in the popup form Conditional Formatting set the Condition 1 settings as follows Cell Value Is equal to =$A$2+1 Click on the Format button and format the text if the result is True e.g. back ground color is Dark Red, font color is white and bold. hope that helps " wrote: value in cell in one digit more than cell above. Is this possible? ex: A 1 3 4 7 4 would be highlighted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight | Excel Discussion (Misc queries) | |||
Highlight | Excel Worksheet Functions | |||
highlight row | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Highlight Row | Excel Worksheet Functions |