LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Condition Format with 2 cell

Can someone give me the right formula to set condition for below

C D E F
3 In the Programme 5,110.39 1,217.39 40.76%
4 Not In Programme 20,079.87 0.00%
5 In the Programme 161,544.56 7,759.40 95.42%

The formula I've been using but it's not right
=AND($C3=""In the Programme,($F3<0.5))

What I want is if cell C = In the programme and cell F is less than 50%,
colour RED.
Example above, cell F3 should be in red.

Thanks.





 
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
Cell format as condition mars Excel Worksheet Functions 1 November 24th 08 02:17 AM
use more than 3 condition in conditional format Montu Excel Worksheet Functions 2 November 20th 07 09:51 AM
Condition Format TQ Excel Discussion (Misc queries) 1 January 4th 07 04:17 AM
multiple condition lookup and match cell format CJ at home Excel Worksheet Functions 3 August 27th 06 03:56 PM
Can I condition format, "if the cell contains a formula" kvail Excel Worksheet Functions 3 June 28th 06 09:01 PM


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