| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting multiple cells from one cell to another
Hi,
Condition 1 will be =OR(C2,C4,C6,C8,C12)=$AK$2 and choose the font format as Blue Condition 2 will be =OR(C3,C5,C7,C9,C11,C13)=$AK$2 and choose the font format as Green -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Loadmaster" wrote in message ... Hi there, I am looking for a conditional formatting formula so that if C2 or C4 or C6 or C8 or C12 = $AK$2 to format cell C4 blue AND if C3 or C5 or C7 or C9 or C11 or C13 = $AK$2 format cell C4 green. Can anyone help me out on this one? I tried entering it in that way and it didn't work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting of Cells with Multiple Cell Values | Excel Discussion (Misc queries) | |||
| multiple cells conditional formatting | Excel Discussion (Misc queries) | |||
| Copying Conditional Formatting to multiple cells | Excel Discussion (Misc queries) | |||
| conditional formatting to multiple cells | Excel Worksheet Functions | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
