Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 16th 10, 09:01 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 9
Default Conditional Formatting on a Row - XL2007

Hi all,

I want to apply a Conditional Format (Bold Red Txt) to the entire
contents of a row when the word 'RECALLED' appears in any of four
specific cells within that row (AJ3, AQ3, AX3 and BE3).

Any pointers/suggestions.

Thanks

--
Steve

There's a fine line between fishing and just standing on the shore like
an idiot.
- Steven Wright

  #2   Report Post  
Old January 16th 10, 11:22 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 1,533
Default Conditional Formatting on a Row - XL2007

Hi Steve

Select the entire table, and goto Conditional Format.

Use 'Formula Is', and enter this formula, where 3 is the number of the first
row in the table:

=OR($AJ3="RECALLED",$AQ3="RECALLED",$AX3="RECALLED ",$BE3="RECALLED")

Apply formatting as desired.

Regards,
Per

"Steve" skrev i meddelelsen
...
Hi all,

I want to apply a Conditional Format (Bold Red Txt) to the entire contents
of a row when the word 'RECALLED' appears in any of four specific cells
within that row (AJ3, AQ3, AX3 and BE3).

Any pointers/suggestions.

Thanks

--
Steve

There's a fine line between fishing and just standing on the shore like an
idiot.
- Steven Wright


  #3   Report Post  
Old January 17th 10, 01:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 9
Default Conditional Formatting on a Row - XL2007

Per Jessen penned:
Hi Steve


Select the entire table, and goto Conditional Format.


Use 'Formula Is', and enter this formula, where 3 is the number of the first
row in the table:


=OR($AJ3="RECALLED",$AQ3="RECALLED",$AX3="RECALLED ",$BE3="RECALLED")


Apply formatting as desired.


Thank you Per, works like a charm

--
Steve

Eat a live toad the first thing in the morning and nothing worse will
happen to you the rest of the day.
- Unknown


Reply
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 Formats XL2007 Telford Tom[_2_] Excel Discussion (Misc queries) 1 November 21st 09 12:13 PM
Conditional Formatting in XL2007 Steve Haack Excel Worksheet Functions 3 August 3rd 08 05:27 PM
Conditional formatting different on XL2007 than XL2003 Stan Excel Discussion (Misc queries) 0 July 16th 08 06:24 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
Conditional Formatting that will display conditional data BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM


All times are GMT +1. The time now is 10:50 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017