LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Conditional format entire row from one cell

I see examples for this where the cell is a numerical value, but I need to do
this where the cell is a person's name. I have 2007 and I went to CF - new
rule- use formula to determine which cells to format. My name is in column
B2 so I put =$B2=NAME and I get an error of "you may not use unions,
intersections, or array constants for CF critera". What is the correct
formula I need to use for this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format an entire row based on one cell Wagman V1 Excel Worksheet Functions 3 August 9th 08 12:09 AM
Conditional Format entire row CrimsonPlague29 Excel Discussion (Misc queries) 3 March 1st 08 02:04 AM
color entire row by using conditional format capital letter Excel Worksheet Functions 1 November 10th 07 09:55 AM
color entire row by using conditional format capital letter Excel Worksheet Functions 1 November 10th 07 09:24 AM
Conditional Format to Highlight entire Row? shital shah Excel Worksheet Functions 1 August 25th 05 04:37 PM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"