Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Format to Highlight entire Row?
Hi I am Useing conditional formatting to highlight items that are in a list
on the worksheet with function =countif($d$1:$d$6,A2) Where my list is from A2:c100 but when i use this function it highlight only that cell how can i highlight row of that data. i.e. a3 to c3 Pls help. ****al |
#2
|
|||
|
|||
I'm not sure i totally follow you, but what if you changed the formula in the conditional formatting window to... =countif($d$1:$d$6,$A2) (Added $ symbol in from of the A in "A2") And applied this conditional format to each cell, column A, B, and C? -- Excel_Geek ------------------------------------------------------------------------ Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423 View this thread: http://www.excelforum.com/showthread...hreadid=398935 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I format an entire row based on the value of a single cell? | Excel Discussion (Misc queries) | |||
Possibly conditional format | Excel Discussion (Misc queries) | |||
Conditional Format Titles | Excel Discussion (Misc queries) | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
Conditional format | Excel Discussion (Misc queries) |