Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple Column Conditional Formatting
Hi,
I'm needing some help with performing a multiple column condition formatting. I have tried many "forumula is" in the conditional formatting with no success. I'm missing something. What I would like to have happen is, if the 2 conditions are true then I want the field to be color filled. Example: if the numeric value in k210 and the numeric value F2100 then I would like cell K2 to be filled in red. Many thanks for your help Colleen |
#2
|
|||
|
|||
one way:
Select K2: CF1: Formula is =AND(K210,F2100) Format1: <patterns/Red In article , "Colleen" wrote: Hi, I'm needing some help with performing a multiple column condition formatting. I have tried many "forumula is" in the conditional formatting with no success. I'm missing something. What I would like to have happen is, if the 2 conditions are true then I want the field to be color filled. Example: if the numeric value in k210 and the numeric value F2100 then I would like cell K2 to be filled in red. Many thanks for your help Colleen |
#3
|
|||
|
|||
Thanks JE. It works great.
-- Many thanks for your help Collee "JE McGimpsey" wrote: one way: Select K2: CF1: Formula is =AND(K210,F2100) Format1: <patterns/Red In article , "Colleen" wrote: Hi, I'm needing some help with performing a multiple column condition formatting. I have tried many "forumula is" in the conditional formatting with no success. I'm missing something. What I would like to have happen is, if the 2 conditions are true then I want the field to be color filled. Example: if the numeric value in k210 and the numeric value F2100 then I would like cell K2 to be filled in red. Many thanks for your help Colleen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
same cell from multiple sheets into one column | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions |