Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can conditional formatting on one cell value to another cell valu
Can Excel conditional formatting be done by comparing the value in one cell
to the value in another cell value |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can conditional formatting on one cell value to another cell valu
Yes it can. Instead of 'cell value is' in the CF dropdown, use 'formula is'.
The formula would be something like =(A1=C1) if you wanted to format A1 conditionally on it being equal to C1, for example. --Bruce "Ring eye" wrote: Can Excel conditional formatting be done by comparing the value in one cell to the value in another cell value |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can conditional formatting on one cell value to another cell v
Bruce, Thanks alot, I was not putting parenthesize around the formula. it
works great "bpeltzer" wrote: Yes it can. Instead of 'cell value is' in the CF dropdown, use 'formula is'. The formula would be something like =(A1=C1) if you wanted to format A1 conditionally on it being equal to C1, for example. --Bruce "Ring eye" wrote: Can Excel conditional formatting be done by comparing the value in one cell to the value in another cell value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |