LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default Formula for Conditional Formatting

I've recently been asked to create some conditional formatting based
on a cell value. Basically what I am trying to do is have the cell
turn red if the value of a cell is outside of a range.

For example, if the value of cell F12 280 OR < 220 then I want the
cell to turn red. The standard conditional formatting has limitations
so I am left to figure out how to write a formula. Can someone assist
me with this?

Here is what I have so far but it does not seem to be working.

=IF(F12280 OR <220) then?????

Thanks in advance for your help.
 
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 Formatting Formula? Doug Excel Worksheet Functions 5 August 6th 09 04:12 AM
conditional formatting OR formula SandyB Excel Discussion (Misc queries) 1 May 29th 08 07:41 PM
Conditional Formatting Formula DHEvans333 Excel Worksheet Functions 1 November 9th 06 08:51 PM
conditional formatting with formula mwc0914 Excel Worksheet Functions 2 July 20th 05 08:11 PM
Conditional Formatting Formula dmorri Excel Programming 9 July 29th 04 04:09 PM


All times are GMT +1. The time now is 09:07 PM.

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"