Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Micayla Bergen
 
Posts: n/a
Default conditional format greater or less than

can i make a formula to change the format of the cell if it is 2 or 1? i have
tried IF FIND and less than greater than but have had no luck thus far
thanks
  #2   Report Post  
patrick
 
Posts: n/a
Default

Look in conditional formatting. Under format. You can change the fontcolor
textboder of the cell with conditions that you set.
Pat

"Micayla Bergen" wrote:

can i make a formula to change the format of the cell if it is 2 or 1? i have
tried IF FIND and less than greater than but have had no luck thus far
thanks

  #3   Report Post  
Micayla Bergen
 
Posts: n/a
Default

I am in conditional formatting, and would like to have the formula for the
condition only if the cell value is either 2 or 1, but am not sure how to
word it correctly

"patrick" wrote:

Look in conditional formatting. Under format. You can change the fontcolor
textboder of the cell with conditions that you set.
Pat

"Micayla Bergen" wrote:

can i make a formula to change the format of the cell if it is 2 or 1? i have
tried IF FIND and less than greater than but have had no luck thus far
thanks

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

Use formula is and

=OR(A1=1.A1=2)

where A1 is the cell with the formatting

--
Regards,

Peo Sjoblom


"Micayla Bergen" wrote in message
...
I am in conditional formatting, and would like to have the formula for the
condition only if the cell value is either 2 or 1, but am not sure how to
word it correctly

"patrick" wrote:

Look in conditional formatting. Under format. You can change the
fontcolor
textboder of the cell with conditions that you set.
Pat

"Micayla Bergen" wrote:

can i make a formula to change the format of the cell if it is 2 or 1?
i have
tried IF FIND and less than greater than but have had no luck thus far
thanks


  #5   Report Post  
Micayla Bergen
 
Posts: n/a
Default

Thank you!

"Peo Sjoblom" wrote:

Use formula is and

=OR(A1=1.A1=2)

where A1 is the cell with the formatting

--
Regards,

Peo Sjoblom


"Micayla Bergen" wrote in message
...
I am in conditional formatting, and would like to have the formula for the
condition only if the cell value is either 2 or 1, but am not sure how to
word it correctly

"patrick" wrote:

Look in conditional formatting. Under format. You can change the
fontcolor
textboder of the cell with conditions that you set.
Pat

"Micayla Bergen" wrote:

can i make a formula to change the format of the cell if it is 2 or 1?
i have
tried IF FIND and less than greater than but have had no luck thus far
thanks



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
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
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
Copying a conditional format Meaux Excel Worksheet Functions 2 November 29th 04 11:19 AM


All times are GMT +1. The time now is 03:30 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"