Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
condition formatting with formula
Hai. I need a hekp to solve this problem of condition formatting with
formula. Please refer to the cell:- A B 1 50 4 2 100 3 3 60 10 4 80 7 5 92 5 If I want to put colour blue colour in A1 to A4 with the condition if B6 If I want to put colour red colour in A1 to A4 with the condition if B4 If I want to put colour blue colour in A1 to A4 with the condition if B2 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
condition formatting with formula
One way:
Select A1:A4 with A1 the active cell. Choose Format/Conditional Formatting... CF1: Formula is =B16 Format1: <blue CF2: Formula is =B14 Format2: <red CF3: Formula is =B12 Format3: <blue In article , BHOOI wrote: Hai. I need a hekp to solve this problem of condition formatting with formula. Please refer to the cell:- A B 1 50 4 2 100 3 3 60 10 4 80 7 5 92 5 If I want to put colour blue colour in A1 to A4 with the condition if B6 If I want to put colour red colour in A1 to A4 with the condition if B4 If I want to put colour blue colour in A1 to A4 with the condition if B2 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Banding with Conditional Formatting with Multiple Conditions | Excel Worksheet Functions |