Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell format as condition | Excel Worksheet Functions | |||
use more than 3 condition in conditional format | Excel Worksheet Functions | |||
Condition Format | Excel Discussion (Misc queries) | |||
multiple condition lookup and match cell format | Excel Worksheet Functions | |||
Can I condition format, "if the cell contains a formula" | Excel Worksheet Functions |