| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Formula is
I need a formula where D6 font colour will respond to M6 on the following
criteria: if M6 is 5 and < 9 then font to change to green bold italic if M6 is 8 then font to change to red bold italic otherwise font to be black (D6 is text and M6 is numerical) Needs to be a nested formula as I have other conditional formatting conditions already applied to the cell. Running excel 2003 Can anyone please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
| Conditional Formatting based on Formula | Excel Worksheet Functions | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
