Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create formulas in conditional formatting
I want to create two types of conditional format (red font versus blue font)
if the following conditions apply. Blue font if (the current cell <.7 AND another cell = "male") OR (if the current cell < .6 AND another cell ' "female) Red font (if the current cell 1.3 AND another cell = "male") OR (if the current cell 1.0 and another cell = "female") What should the formulas look like? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting and Formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting for Formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting-No Formulas | Excel Worksheet Functions | |||
How do I create conditional excel formulas? | Excel Worksheet Functions | |||
Conditional Formatting - Formulas | Excel Discussion (Misc queries) |