If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting refering to another cells' value
Hi guys,
I wonder if it's possible to format conditionally a cell according to the value in another cell. F. ex., we format cell A1 like this: If value in cell A2 = mam (specific text string 1), color the cell A1 in purple if value in cell A2 = dad (specific text string 2), color the cell A1 in red if value in cell A2 = 534 (any number string 3), color the cell A1 in blue Intuitively, I would use 3 different conditions, starting with "formula is" and then A2=mam (or dad, or...). But it's not working. Any idea why? Thanks a lot for your help! Cheers, Gizmo |
#2
|
|||
|
|||
Did you forget to start the formula with " = "?
Did you forget to use quotes for the text "..." ? =A2="mam" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "gizmo" wrote in message ... Hi guys, I wonder if it's possible to format conditionally a cell according to the value in another cell. F. ex., we format cell A1 like this: If value in cell A2 = mam (specific text string 1), color the cell A1 in purple if value in cell A2 = dad (specific text string 2), color the cell A1 in red if value in cell A2 = 534 (any number string 3), color the cell A1 in blue Intuitively, I would use 3 different conditions, starting with "formula is" and then A2=mam (or dad, or...). But it's not working. Any idea why? Thanks a lot for your help! Cheers, Gizmo |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting over a picture | Carl Rapson | Setting Up & Running Reports | 0 | December 27th, 2004 04:21 PM |
Conditional Formatting | Art | General Discussion | 4 | June 13th, 2004 04:14 PM |
Conditional formatting with formula | Ann Scharpf | Worksheet Functions | 5 | October 21st, 2003 04:29 AM |