| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format on another cell's value
Hello,
I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format on another cell's value
Try this:
Formula Is: =B1<$A1 What about empty cells? Do you need to account for empty cells? -- Biff Microsoft Excel MVP "RicardoE" wrote in message ... Hello, I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format on another cell's value
Thanks! That works pretty well! Except, as you indicated, empty cells will
also be highlighted RED. What can I do in that case? I want empty cells to be ignored. "T. Valko" wrote: Try this: Formula Is: =B1<$A1 What about empty cells? Do you need to account for empty cells? -- Biff Microsoft Excel MVP "RicardoE" wrote in message ... Hello, I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format on another cell's value
Try this:
=AND($A1<"",B1<"",B1<$A1) -- Biff Microsoft Excel MVP "RicardoE" wrote in message ... Thanks! That works pretty well! Except, as you indicated, empty cells will also be highlighted RED. What can I do in that case? I want empty cells to be ignored. "T. Valko" wrote: Try this: Formula Is: =B1<$A1 What about empty cells? Do you need to account for empty cells? -- Biff Microsoft Excel MVP "RicardoE" wrote in message ... Hello, I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format on another cell's value
Cool I figured it out, it's pretty easy. I have two conditions for my formulae: Condition #1: =COUNTBLANK(L2)=1 then color the FONT in this cell BLUE... of course this won't do anything since the cell is empty anyway! Condition #2: =$B2<$L2 then color the cell RED, which is what I want And if they are equal, then the cell remains as is (no color). Thanks for your help! Ricky. "RicardoE" wrote: Thanks! That works pretty well! Except, as you indicated, empty cells will also be highlighted RED. What can I do in that case? I want empty cells to be ignored. "T. Valko" wrote: Try this: Formula Is: =B1<$A1 What about empty cells? Do you need to account for empty cells? -- Biff Microsoft Excel MVP "RicardoE" wrote in message ... Hello, I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format on another cell's value
That's beautiful, love the logic function! I'll use the AND function.
Thanks a bunch, nicely done! :-) Ricky "RicardoE" wrote: Cool I figured it out, it's pretty easy. I have two conditions for my formulae: Condition #1: =COUNTBLANK(L2)=1 then color the FONT in this cell BLUE... of course this won't do anything since the cell is empty anyway! Condition #2: =$B2<$L2 then color the cell RED, which is what I want And if they are equal, then the cell remains as is (no color). Thanks for your help! Ricky. "RicardoE" wrote: Thanks! That works pretty well! Except, as you indicated, empty cells will also be highlighted RED. What can I do in that case? I want empty cells to be ignored. "T. Valko" wrote: Try this: Formula Is: =B1<$A1 What about empty cells? Do you need to account for empty cells? -- Biff Microsoft Excel MVP "RicardoE" wrote in message ... Hello, I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format on another cell's value
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "RicardoE" wrote in message ... That's beautiful, love the logic function! I'll use the AND function. Thanks a bunch, nicely done! :-) Ricky "RicardoE" wrote: Cool I figured it out, it's pretty easy. I have two conditions for my formulae: Condition #1: =COUNTBLANK(L2)=1 then color the FONT in this cell BLUE... of course this won't do anything since the cell is empty anyway! Condition #2: =$B2<$L2 then color the cell RED, which is what I want And if they are equal, then the cell remains as is (no color). Thanks for your help! Ricky. "RicardoE" wrote: Thanks! That works pretty well! Except, as you indicated, empty cells will also be highlighted RED. What can I do in that case? I want empty cells to be ignored. "T. Valko" wrote: Try this: Formula Is: =B1<$A1 What about empty cells? Do you need to account for empty cells? -- Biff Microsoft Excel MVP "RicardoE" wrote in message ... Hello, I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format on another cell's value
yes
"RicardoE" wrote: Hello, I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to recognize if another cell's conditional format is true | Excel Discussion (Misc queries) | |||
| CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct) | Excel Discussion (Misc queries) | |||
| Conditional Format based on other cell's value | Excel Worksheet Functions | |||
| Creating a conditional format for a cell based on another cell's v | Excel Discussion (Misc queries) | |||
| Locking a cell's format, but not value | Excel Discussion (Misc queries) | |||
Linear Mode
