Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
I need to set conditional formatting where A1 is formatted to bold if B1 =
"Open", same for A2 if B2 = "Open", A3 if B3 = "Open" and so on. Is there a way I can do this formatting all at once as oposed to formatting each "A" cell individually |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Hi!
There is one: select your range in the column A, go in the Conditional formatting box, choose 'Formula Is' (and not 'Cell Value Is' as per default), fill in with =B1="Open" (if active cell is A1) and use the format you want to... Does it work? -- A+ V. "Jet" wrote: I need to set conditional formatting where A1 is formatted to bold if B1 = "Open", same for A2 if B2 = "Open", A3 if B3 = "Open" and so on. Is there a way I can do this formatting all at once as oposed to formatting each "A" cell individually |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Select all the cells that need conditional formatting. Select Conditional Formatting Formula is: =$a1="open" -- MABeatty ------------------------------------------------------------------------ MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258 View this thread: http://www.excelforum.com/showthread...hreadid=555003 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
It worked like a charm, thank you very much, and greetings from Montreal
Canada! Jet "Vincnet." wrote: Hi! There is one: select your range in the column A, go in the Conditional formatting box, choose 'Formula Is' (and not 'Cell Value Is' as per default), fill in with =B1="Open" (if active cell is A1) and use the format you want to... Does it work? -- A+ V. "Jet" wrote: I need to set conditional formatting where A1 is formatted to bold if B1 = "Open", same for A2 if B2 = "Open", A3 if B3 = "Open" and so on. Is there a way I can do this formatting all at once as oposed to formatting each "A" cell individually |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |