| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
highlight column A if column A does not equal to B
How can I do that?
Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
highlight column A if column A does not equal to B
Also can I highlight a cell if it's of a certain value, eg. 0?
|
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
highlight column A if column A does not equal to B
FormatConditional FormattingCell Value is: equal to 0
Format to a color and OK Gord Dibben MS Excel MVP On Thu, 1 May 2008 15:58:29 -0700 (PDT), liu wrote: Also can I highlight a cell if it's of a certain value, eg. 0? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
highlight column A if column A does not equal to B
Select a range in column A and FormatConditional FormattingFormula is:
=$B1<$A1 Format to a color and OK. Gord Dibben MS Excel MVP On Thu, 1 May 2008 15:57:31 -0700 (PDT), liu wrote: How can I do that? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum column a if column b, c, d, and e are equal | Excel Worksheet Functions | |||
| Need to sum a column if two cells in row are equal | Excel Worksheet Functions | |||
| How do I highlight a column depending on other column value? | Excel Worksheet Functions | |||
| first number in a column not equal to zero | New Users to Excel | |||
| How do I get text to equal a number so I can sum a column? | Excel Discussion (Misc queries) | |||
Hybrid Mode
