Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Hightlight row based on one condition)
Hi,
I've looked through the conditional formatting section but can't find anything. Here is my problem... A B C D E 1 DD SS WW 1 2 SS QQ EE 4 Now what I require is for section A1-D1 to highlight in red when A1=E1, so for my example I would only expect to see one row highlighted because there is only one match. Your help again is much appreciated. Regards, James. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Hightlight row based on one condition)
Block the entire range you want to format conditionally - in your example's
case, A1:D2 Click on Formatting, select Conditional Formatting, and in the window that then pops up, change Cell Value Is to Formula Is. In the box to the right of this type =$A1=$E1. Click on the format button, select Patterns, select Red, and OK out "Jamesy" wrote: Hi, I've looked through the conditional formatting section but can't find anything. Here is my problem... A B C D E 1 DD SS WW 1 2 SS QQ EE 4 Now what I require is for section A1-D1 to highlight in red when A1=E1, so for my example I would only expect to see one row highlighted because there is only one match. Your help again is much appreciated. Regards, James. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Hightlight row based on one condition)
one way:
Select columns A-D, with A1 as the active cell. Choose Format/Conditional Formatting and use the dropdowns and input box to enter: CF1: Formula is =$A1=$E1 Format1: <patterns/<your color here In article , Jamesy wrote: Hi, I've looked through the conditional formatting section but can't find anything. Here is my problem... A B C D E 1 DD SS WW 1 2 SS QQ EE 4 Now what I require is for section A1-D1 to highlight in red when A1=E1, so for my example I would only expect to see one row highlighted because there is only one match. Your help again is much appreciated. Regards, James. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting (Hightlight row based on one condition)
Thank you both for your comments!!
As usual spot on! James. "JE McGimpsey" wrote: one way: Select columns A-D, with A1 as the active cell. Choose Format/Conditional Formatting and use the dropdowns and input box to enter: CF1: Formula is =$A1=$E1 Format1: <patterns/<your color here In article , Jamesy wrote: Hi, I've looked through the conditional formatting section but can't find anything. Here is my problem... A B C D E 1 DD SS WW 1 2 SS QQ EE 4 Now what I require is for section A1-D1 to highlight in red when A1=E1, so for my example I would only expect to see one row highlighted because there is only one match. Your help again is much appreciated. Regards, James. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Getting pass the 3 condition limit | Excel Discussion (Misc queries) | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
Conditional formatting based on decision to enable/disable macros? | Excel Discussion (Misc queries) | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) |