Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
George Gee
 
Posts: n/a
Default Conditional Format

Hi all,

Can someone help me with this conditional format problem?

I am trying to express the following:

If the number in cell B3 can be found in the range J1:O1,
then the condition is true.

The number in B3 is constant (35), the values in range J1:O1
change weekly.

Many thanks

George Gee


  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Use formula is and

=COUNTIF(J1:O1,B3)0

--

Regards,

Peo Sjoblom

"George Gee" wrote in message
...
Hi all,

Can someone help me with this conditional format problem?

I am trying to express the following:

If the number in cell B3 can be found in the range J1:O1,
then the condition is true.

The number in B3 is constant (35), the values in range J1:O1
change weekly.

Many thanks

George Gee




  #3   Report Post  
George Gee
 
Posts: n/a
Default

Peo

Many thanks, the formula is spot on!

George Gee

*Peo Sjoblom* has posted this message:

Use formula is and

=COUNTIF(J1:O1,B3)0

--

Regards,

Peo Sjoblom

"George Gee" wrote in message
...
Hi all,

Can someone help me with this conditional format problem?

I am trying to express the following:

If the number in cell B3 can be found in the range J1:O1,
then the condition is true.

The number in B3 is constant (35), the values in range J1:O1
change weekly.

Many thanks

George Gee



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 format Julian Campbell Excel Worksheet Functions 2 December 16th 04 12:59 AM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 8th 04 12:02 AM
make a conditional format the default Fred Evans Excel Discussion (Misc queries) 3 December 6th 04 06:01 AM
Conditional format rexmann Excel Discussion (Misc queries) 4 December 2nd 04 01:01 PM
Copying a conditional format Meaux Excel Worksheet Functions 2 November 29th 04 11:19 AM


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

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

About Us

"It's about Microsoft Excel"