Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to do a conditional formatting based on an adjacent cell
I want to conditionally format a cell if a different cell has contains
certain data. I only know how to do this based on the selected cells contents. Can anyone help? |
#2
|
|||
|
|||
Format / CF / Change 'Cell Value is' to 'Formula is' and then use normal
formulas with cell references. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Confused" wrote in message ... I want to conditionally format a cell if a different cell has contains certain data. I only know how to do this based on the selected cells contents. Can anyone help? |
#3
|
|||
|
|||
To CF A1 when B1 is equal to "confused".......
Select A1 then FormatCFFormula is: =B1="confused" Pick a format and OK your way out. Gord Dibben Excel MVP On Mon, 10 Jan 2005 12:05:04 -0800, "Confused" wrote: I want to conditionally format a cell if a different cell has contains certain data. I only know how to do this based on the selected cells contents. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |