Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format adjacent cells
I need to format a cell (change it to red) when the cell adjacent to it
contains the character "x". I did try to look at tthe conditional formating but colud not find a specific formula to do this, can anyone help me |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format adjacent cells
Conditional Formatting
=A1="x" Format any color you want "vic" wrote: I need to format a cell (change it to red) when the cell adjacent to it contains the character "x". I did try to look at tthe conditional formating but colud not find a specific formula to do this, can anyone help me |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format adjacent cells
One formula,
=ISNUMBER(SEARCH("x",A1)) Regards, Alan. "vic" wrote in message ... I need to format a cell (change it to red) when the cell adjacent to it contains the character "x". I did try to look at tthe conditional formating but colud not find a specific formula to do this, can anyone help me |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format adjacent cells
In the conditional formatting dialog, choose Formula Is instead of Value is,
then type in this formula as shown, changing the F16 to the cell address you are setting conditional formatting for. =OFFSET(F16,0,-1)="X" In this case, when E16 contains x or X, then the conditional formatting will change F16. You can fill this left/right/up/down as needed - but will result in an error if you fill all the way into column A, since there is no column to the left of column A. Hope it helps you out. "vic" wrote: I need to format a cell (change it to red) when the cell adjacent to it contains the character "x". I did try to look at tthe conditional formating but colud not find a specific formula to do this, can anyone help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why will my cells not format? | New Users to Excel | |||
how do i add in numbers automatically based on adjacent cells cont | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) |